协议sql
```sql
SELECT * from MPLTPAGR WHERE MPL_PRD_NO='888099200000007' and ACT_ORG_ID='XXBL-FAC';
--用户保理服务协议
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPCHBLLOAN', 3,'用户保理服务协议', 'bphonexy_credit_loans.html', 'BAOLI_YUSHEN', to_char(sysdate,'yyyymmddhh24miss'),'facFengYunXXLoan1','XXBL-FAC','0');
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPCHLOAN', 5,'用户保理服务协议', 'factorfengyun1.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'facFengYunXXLoan1','XXBL-FAC','0');
--用户授权服务协议
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPLOANCUM', 1,'用户授权服务协议', 'bphonexy_credit_loans.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'facFengYunXXAuthCUM1','XXBL-FAC','0');
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPAUTHCUM', 4,'用户授权服务协议', 'factorshijiyt1.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'facFengYunXXAuthCUM1','XXBL-FAC','0');
--信息查询授权及隐私协议书
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPAUTHCUM', 2,'信息查询授权及隐私协议书', 'factorshijiyt1.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'facFengYunXXAuthCUM2','XXBL-FAC','0');
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPLOANCUM1', 2,'信息查询授权及隐私协议书', 'bphonexy_credit_loans.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'facFengYunXXAuthCUM2','XXBL-FAC','0');
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
--和包客户告知书
('888099200000007', 'CPAUTHCUM', 3,'和包客户告知书', 'factorshijiyt1.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'facAuthCUM1','XXBL-FAC','0');
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPLOANCUM2', 3,'和包客户告知书', 'bphonexy_credit_loans.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'facAuthCUM1','XXBL-FAC','0');
--用户服务协议
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPAUTHCUM', 1,'用户服务协议', 'factorshijiyt1.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'privateAgreement','XXBL-FAC','0');
INSERT INTO MPLADM.MPLTPAGR (MPL_PRD_NO, AGR_TYP, AGR_SEQ, AGR_NM, AGR_URL, RMK, TM_SMP, AGR_TAG, ACT_ORG_ID, DIS_FLG) VALUES
('888099200000007', 'CPLOANCUM3', 1,'用户服务协议', 'bphonexy_credit_loans.html', ' ', to_char(sysdate,'yyyymmddhh24miss'),'privateAgreement','XXBL-FAC','0');
SELECT * from MPLTPAGR WHERE MPL_PRD_NO='888099200000007' and ACT_ORG_ID='JCBL-FAC';
SELECT * from MPLTPAGR WHERE MPL_PRD_NO='888099200000007' and ACT_ORG_ID='XXBL-FAC';
select * from MPLADM.MPLTPAGRTMP where mpl_prd_no = '888099200000007' and ACT_ORG_ID = 'JCBL-FAC';
--------门店协议--------
SELECT * from MPLTBUSPARM WHERE PARM_VAL1 = '888099200000007' and PARM_VAL2='JCBL-FAC' and PARM_NM='FAC_CONT_PDF_NM'
INSERT INTO MPLADM.MPLTBUSPARM (PARM_NO, PARM_NM, PARM_VAL1, PARM_VAL2, PARM_VAL3, PARM_VAL4, PARM_VAL5, PARM_DES, OPR_ID, OPR_DT, OPR_TM, TM_SMP, PARM_VAL6, PARM_VAL7, PARM_VAL8)
VALUES (to_char(sysdate,'yyyymmddhh24miss') || MPL_PUB_SEQ.nextval, 'FAC_CONT_PDF_NM', '888099200000007', 'XXBL-FAC', 'FT_FACTORING_XX_DEPAUTH.pdf', '0', null, '保理门店导出合同模板', 'SYS', to_char(sysdate,'yyyymmdd'), to_char(sysdate,'hh24miss'), to_char(sysdate,'yyyymmddhh24miss'), null, null, null);
SELECT * from MPLTBUSPARM WHERE PARM_VAL1 = '888099200000007' and PARM_VAL3='XXBL-FAC' and PARM_NM='FAC_ACT_ORG_PACT'
INSERT INTO MPLADM.MPLTBUSPARM (PARM_NO, PARM_NM, PARM_VAL1, PARM_VAL2, PARM_VAL3, PARM_VAL4, PARM_VAL5, PARM_DES, OPR_ID, OPR_DT, OPR_TM, TM_SMP, PARM_VAL6, PARM_VAL7, PARM_VAL8)
VALUES (to_char(sysdate,'yyyymmddhh24miss') || MPL_PUB_SEQ.nextval, 'FAC_ACT_ORG_PACT', '888099200000007', '/mpl/pact/facFengyunXXDep.xhtml', 'XXBL-FAC', '0', null, '保理门店签约资方协议地址', 'SYS', to_char(sysdate,'yyyymmdd'), to_char(sysdate,'hh24miss'), to_char(sysdate,'yyyymmddhh24miss'), null, null, null);
----------
select * from MPLTACTORGN where ACT_ORG_ID='XXBL-FAC' and ORG_ID = '888099200000007';
SELECT * from MPLTBUSPARM WHERE PARM_VAL1='888099200000007'
--------------
select * from MPLADM.MPLTPAGRTMP where mpl_prd_no = '888099200000007' and ACT_ORG_ID = 'XXBL-FAC';
insert into MPLTPAGRTMP(jrn_no,mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,PDF_TAG_NM,init_flg,Tm_Smp,SIGN_PAGE)
select to_char(sysdate, 'yyyymmddhh24miss') || PUBSJRN.NEXTVAL, mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,agr_tag,'Y',to_char(sysdate,'YYYYMMDDHH24MISS'),'7'
from mpltpagr where mpl_prd_no = '888099200000007'
AND AGR_TAG in ('facFengYunXXLoan1');
insert into MPLTPAGRTMP(jrn_no,mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,PDF_TAG_NM,init_flg,Tm_Smp,SIGN_PAGE)
select to_char(sysdate, 'yyyymmddhh24miss') || PUBSJRN.NEXTVAL, mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,agr_tag,'Y',to_char(sysdate,'YYYYMMDDHH24MISS'),'2'
from mpltpagr where mpl_prd_no = '888099200000007'
AND AGR_TAG in ('facFengYunXXAuthCUM1');
insert into MPLTPAGRTMP(jrn_no,mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,PDF_TAG_NM,init_flg,Tm_Smp,SIGN_PAGE)
select to_char(sysdate, 'yyyymmddhh24miss') || PUBSJRN.NEXTVAL, mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,agr_tag,'Y',to_char(sysdate,'YYYYMMDDHH24MISS'),'1'
from mpltpagr where mpl_prd_no = '888099200000007'
AND AGR_TAG in ('facXXAuthCUM1');
insert into MPLTPAGRTMP(jrn_no,mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,PDF_TAG_NM,init_flg,Tm_Smp,SIGN_PAGE)
select to_char(sysdate, 'yyyymmddhh24miss') || PUBSJRN.NEXTVAL, mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,agr_tag,'Y',to_char(sysdate,'YYYYMMDDHH24MISS'),'9'
from mpltpagr where mpl_prd_no = '888099200000007' AND AGR_TAG in ('facFengYunXXAuthCUM2');
insert into MPLTPAGRTMP(jrn_no,mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,PDF_TAG_NM,init_flg,Tm_Smp,SIGN_PAGE)
select to_char(sysdate, 'yyyymmddhh24miss') || PUBSJRN.NEXTVAL, mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,agr_tag,'Y',to_char(sysdate,'YYYYMMDDHH24MISS'),'1'
from mpltpagr where mpl_prd_no = '888099200000007' AND AGR_TAG in ('privateAgreement');
insert into MPLTPAGRTMP(jrn_no,mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,PDF_TAG_NM,init_flg,Tm_Smp,SIGN_PAGE)
select to_char(sysdate, 'yyyymmddhh24miss') || PUBSJRN.NEXTVAL, mpl_prd_no,agr_typ,agr_seq,agr_nm,agr_url,rmk,agr_tag,Dis_Flg,act_org_id,agr_tag,'Y',to_char(sysdate,'YYYYMMDDHH24MISS'),'1'
from mpltpagr where mpl_prd_no = '888099200000007' AND AGR_TAG in ('facAuthCUM1');
-----------------
----------toucan
SELECT A.ORG_ID,A.ORG_NM,B.ACT_ORG_ID,B.ACT_ORG_NM,C.PARM_VAL2 PDF_URL,C.PARM_VAL5 AGR_NM,C.PARM_VAL6 AGR_TYP,C.PARM_NO AGR_ID
FROM MPLTCPTORGN A,MPLTACTORGN B,MPLTBUSPARM C
WHERE A.ORG_ID=B.ORG_ID
AND B.EFF_FLG='1'
AND A.EFF_FLG = '1'
AND A.ORG_ID = C.PARM_VAL1
AND C.PARM_NM = 'FAC_ACT_ORG_PACT'
AND C.PARM_VAL3=B.ACT_ORG_ID
AND A.ORG_ID='888099200000007'
ORDER BY B.ACT_ORG_ID,C.PARM_VAL6
---------------
select * from MPLTCKPM where CHK_ORG_ID='888099200000007'
```