兴业sql
```sql
SELECT * FROM MPLTACTORGN where ORG_ID='888099200000001';
/*查看日期*/
SELECT * FROM mpltpubdt;
-- 订单表
select * FROM mpltcptordt where MBL_NO='15274819172' and ORD_NO='50620220629130001000359270';
select * FROM mpltcptordt where MBL_NO='18707489552';
select * FROM mpltcptordt where MBL_NO='18684748230' and ORD_DT='20220614'; --and ORD_NO='50620220622133333000353236';
-- 省份表
SELECT * from MPLTPROVINF where PROV_NO='18';
-- alter table MPLADM.MPLTPROVINF add (GOODS_RETURN_FLG VARCHAR2(1) default '1' not null);
-- comment on column MPLADM.MPLTPROVINF.GOODS_RETURN_FLG is 'S1P退货';
-- 门店信息
SELECT * from MPLTCPTDEPINF WHERE EFF_FLG = '1' AND DEP_ID='YYZTEST';
UPDATE MPLTCPTDEPINF SET PROV_NO='18' WHERE EFF_FLG = '1' AND DEP_ID='YYZTEST';
-- 更改告知书状态
SELECT * from MPLTIMGCHK WHERE ORD_NO='50620220625142011000356097';
UPDATE MPLTIMGCHK SET CHK_STS='S' WHERE ORD_NO='50620220625142011000356097';
-- 接口地址
SELECT * FROM MPLTBUSTXCD WHERE MPL_PRD_TYP = '002'AND BUS_ORG_ID='888073155233179';
/*查看类型*/
SELECT * FROM MPLTCKPM WHERE CHK_ORG_ID = '888099200000002' AND CHK_TYP_ID='FC001';
-- 上传sftp 信息
SELECT * FROM FILTURLCFG WHERE SYS_TYP = '1' AND SYS_CNL = 'MPL' AND FIL_TYP = '0' AND BUS_CNL = 'XYXJ';
-- 根据流水找日志
SELECT * FROM MPLTCREDITCPT WHERE ORG_ID='888073155233179' AND ID_NO18='D86FC52A790A6A366FE8E5CA23A0ABC83121F5B23FBB9FE5';
SELECT * from MPLTCPTCREJRN WHERE ORG_ID='888073155233179' AND ID_NO18='D86FC52A790A6A366FE8E5CA23A0ABC83121F5B23FBB9FE5';
SELECT * from MPLTBUSTXJRN where ROWNUM<11;
----------------------------------------------------------------------------
SELECT * FROM MPLTCPTORGN WHERE ORG_ID = '888099200000002' AND EFF_FLG = '1';
select * from MPLTPROVINF where PROV_NO='18';
SELECT * FROM(SELECT ROWNUM RN,TA.* FROM( SELECT *
FROM MPLAUDITINGINF
WHERE ADD_DT BETWEEN '20220629' AND '20220629'
AND EFF_FLG='1'
ORDER BY ADD_DT DESC )TA WHERE ROWNUM <= '15' )WHERE RN >= '1';
select * from MPLADM.MPLTCKPM where CHK_ORG_ID='888099200000001';
select * from MPLADM.MPLTBUSTXCD where BUS_ORG_ID='888099200000001';
select * from MPLTDEPACTSIGN;
SELECT *
FROM MPLTCPTDEPINF A
WHERE
A.EFF_FLG='1'
AND A.DEP_ID = ?;
select * from MPLTDEPCONT where CON_TX_DT='20520623' and TX_TM='160949';
select * from MPLTCPTDEPINF;
select * from MPLTDEPSIGN where DEP_ID='18-sht';
select * from MPLTDEPCONT where DEP_ID='18-sht';
```