APPS.GMI_ICR03_XMLP_PKG dependencies on OP_BILL_LAD

Line 94: OP_BILL_LAD B1,

90: SELECT
91: B1.BOL_NO
92: INTO D_NO
93: FROM
94: OP_BILL_LAD B1,
95: OP_BILL_LAD B2,
96: OP_ORDR_DTL D,
97: OP_CUST_MST V,
98: OP_SHIP_MST S

Line 95: OP_BILL_LAD B2,

91: B1.BOL_NO
92: INTO D_NO
93: FROM
94: OP_BILL_LAD B1,
95: OP_BILL_LAD B2,
96: OP_ORDR_DTL D,
97: OP_CUST_MST V,
98: OP_SHIP_MST S
99: WHERE B1.BOL_ID = DOC_ID

Line 117: OP_BILL_LAD B1,

113: SELECT
114: B1.BOL_NO
115: INTO D_NO
116: FROM
117: OP_BILL_LAD B1,
118: OP_ORDR_DTL D,
119: OP_CUST_MST V,
120: OP_SHIP_MST S
121: WHERE D.INVOICE_ID = DOC_ID

Line 328: OP_BILL_LAD B1,

324: SELECT
325: V.CUST_NO
326: INTO V_S_L
327: FROM
328: OP_BILL_LAD B1,
329: OP_BILL_LAD B2,
330: OP_ORDR_DTL D,
331: OP_CUST_MST V,
332: OP_SHIP_MST S

Line 329: OP_BILL_LAD B2,

325: V.CUST_NO
326: INTO V_S_L
327: FROM
328: OP_BILL_LAD B1,
329: OP_BILL_LAD B2,
330: OP_ORDR_DTL D,
331: OP_CUST_MST V,
332: OP_SHIP_MST S
333: WHERE B1.BOL_ID = DOC_ID

Line 351: OP_BILL_LAD B1,

347: SELECT
348: V.CUST_NO
349: INTO V_S_L
350: FROM
351: OP_BILL_LAD B1,
352: OP_ORDR_DTL D,
353: OP_CUST_MST V,
354: OP_SHIP_MST S
355: WHERE D.INVOICE_ID = DOC_ID

Line 447: OP_BILL_LAD B1,

443: SELECT
444: D.FRTBILL_MTHD
445: INTO F_M
446: FROM
447: OP_BILL_LAD B1,
448: OP_BILL_LAD B2,
449: OP_ORDR_DTL D,
450: OP_CUST_MST V,
451: OP_SHIP_MST S

Line 448: OP_BILL_LAD B2,

444: D.FRTBILL_MTHD
445: INTO F_M
446: FROM
447: OP_BILL_LAD B1,
448: OP_BILL_LAD B2,
449: OP_ORDR_DTL D,
450: OP_CUST_MST V,
451: OP_SHIP_MST S
452: WHERE B1.BOL_ID = DOC_ID

Line 470: OP_BILL_LAD B1,

466: SELECT
467: D.FRTBILL_MTHD
468: INTO F_M
469: FROM
470: OP_BILL_LAD B1,
471: OP_ORDR_DTL D,
472: OP_CUST_MST V,
473: OP_SHIP_MST S
474: WHERE D.INVOICE_ID = DOC_ID

Line 566: OP_BILL_LAD B1,

562: SELECT
563: D.SHIP_MTHD
564: INTO S_M
565: FROM
566: OP_BILL_LAD B1,
567: OP_BILL_LAD B2,
568: OP_ORDR_DTL D,
569: OP_CUST_MST V,
570: OP_SHIP_MST S

Line 567: OP_BILL_LAD B2,

563: D.SHIP_MTHD
564: INTO S_M
565: FROM
566: OP_BILL_LAD B1,
567: OP_BILL_LAD B2,
568: OP_ORDR_DTL D,
569: OP_CUST_MST V,
570: OP_SHIP_MST S
571: WHERE B1.BOL_ID = DOC_ID

Line 589: OP_BILL_LAD B1,

585: SELECT
586: D.SHIP_MTHD
587: INTO S_M
588: FROM
589: OP_BILL_LAD B1,
590: OP_ORDR_DTL D,
591: OP_CUST_MST V,
592: OP_SHIP_MST S
593: WHERE D.INVOICE_ID = DOC_ID

Line 685: OP_BILL_LAD B1,

681: SELECT
682: S.SHIPPER_NAME
683: INTO S_N
684: FROM
685: OP_BILL_LAD B1,
686: OP_BILL_LAD B2,
687: OP_ORDR_DTL D,
688: OP_CUST_MST V,
689: OP_SHIP_MST S

Line 686: OP_BILL_LAD B2,

682: S.SHIPPER_NAME
683: INTO S_N
684: FROM
685: OP_BILL_LAD B1,
686: OP_BILL_LAD B2,
687: OP_ORDR_DTL D,
688: OP_CUST_MST V,
689: OP_SHIP_MST S
690: WHERE B1.BOL_ID = DOC_ID

Line 708: OP_BILL_LAD B1,

704: SELECT
705: S.SHIPPER_NAME
706: INTO S_N
707: FROM
708: OP_BILL_LAD B1,
709: OP_ORDR_DTL D,
710: OP_CUST_MST V,
711: OP_SHIP_MST S
712: WHERE D.INVOICE_ID = DOC_ID