V7核心系统全表提数

核心系统提数

SELECT * FROM WEB_PLY_BASE A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_CVRG A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_APPLICANT A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_INSURED A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_TGT A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_TGT_OBJ A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_ENT_TGT A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_ACCTINFO A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_BNFC A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_CI A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_FEE A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_PAY A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_APP_GRP_MEMBER A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_EDR_GRP_MEMBER A WHERE A.C_PLY_NO = '&plyno';
SELECT * FROM WEB_PLY_CARGO A WHERE A.C_PLY_NO = '&plyno'; --02
SELECT * FROM WEB_PLY_CARGO_LIST A WHERE A.C_PLY_NO = '&plyno'; --02

SELECT * FROM WEB_APP_BASE A WHERE A.C_PLY_NO = '&plyno';
SELECT *
  FROM WEB_APP_CVRG A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_APPLICANT A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_INSURED A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_TGT A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_TGT_OBJ A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_ENT_TGT A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_ACCTINFO A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_BNFC A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_CI A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_FEE A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_APP_PAY A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno');
SELECT *
  FROM WEB_PLY_CARGO A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno'); --02
SELECT *
  FROM WEB_PLY_CARGO_LIST A
 WHERE A.C_APP_NO IN
       (SELECT B.C_APP_NO FROM WEB_APP_BASE B WHERE B.C_PLY_NO = '&plyno'); --02

 

转载于:https://www.cnblogs.com/ycyang/p/6880869.html