eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_ICR03_XMLP_PKG dependencies on OP_CUST_MST

Line 54: OP_CUST_MST V,

50: INTO D_NO
51: FROM
52: OP_ORDR_HDR H,
53: OP_ORDR_DTL D,
54: OP_CUST_MST V,
55: OP_SHIP_MST S
56: WHERE D.ORDER_ID = DOC_ID
57: AND D.LINE_ID = LINE_ID1
58: AND D.ITEM_ID = ITEM_ID1

Line 97: OP_CUST_MST V,

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
100: AND D.LINE_ID = LINE_ID1
101: AND D.ITEM_ID = ITEM_ID1

Line 119: OP_CUST_MST V,

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
122: AND D.LINE_ID = LINE_ID1
123: AND D.ITEM_ID = ITEM_ID1

Line 288: OP_CUST_MST V,

284: INTO V_S_L
285: FROM
286: OP_ORDR_HDR H,
287: OP_ORDR_DTL D,
288: OP_CUST_MST V,
289: OP_SHIP_MST S
290: WHERE D.ORDER_ID = DOC_ID
291: AND D.LINE_ID = LINE_ID1
292: AND D.ITEM_ID = ITEM_ID1

Line 331: OP_CUST_MST V,

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
334: AND D.LINE_ID = LINE_ID1
335: AND D.ITEM_ID = ITEM_ID1

Line 353: OP_CUST_MST V,

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
356: AND D.LINE_ID = LINE_ID1
357: AND D.ITEM_ID = ITEM_ID1

Line 407: OP_CUST_MST V,

403: INTO F_M
404: FROM
405: OP_ORDR_HDR H,
406: OP_ORDR_DTL D,
407: OP_CUST_MST V,
408: OP_SHIP_MST S
409: WHERE D.ORDER_ID = DOC_ID
410: AND D.LINE_ID = LINE_ID1
411: AND D.ITEM_ID = ITEM_ID1

Line 450: OP_CUST_MST V,

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
453: AND D.LINE_ID = LINE_ID1
454: AND D.ITEM_ID = ITEM_ID1

Line 472: OP_CUST_MST V,

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
475: AND D.LINE_ID = LINE_ID1
476: AND D.ITEM_ID = ITEM_ID1

Line 526: OP_CUST_MST V,

522: INTO S_M
523: FROM
524: OP_ORDR_HDR H,
525: OP_ORDR_DTL D,
526: OP_CUST_MST V,
527: OP_SHIP_MST S
528: WHERE D.ORDER_ID = DOC_ID
529: AND D.LINE_ID = LINE_ID1
530: AND D.ITEM_ID = ITEM_ID1

Line 569: OP_CUST_MST V,

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
572: AND D.LINE_ID = LINE_ID1
573: AND D.ITEM_ID = ITEM_ID1

Line 591: OP_CUST_MST V,

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
594: AND D.LINE_ID = LINE_ID1
595: AND D.ITEM_ID = ITEM_ID1

Line 645: OP_CUST_MST V,

641: INTO S_N
642: FROM
643: OP_ORDR_HDR H,
644: OP_ORDR_DTL D,
645: OP_CUST_MST V,
646: OP_SHIP_MST S
647: WHERE D.ORDER_ID = DOC_ID
648: AND D.LINE_ID = LINE_ID1
649: AND D.ITEM_ID = ITEM_ID1

Line 688: OP_CUST_MST V,

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
691: AND D.LINE_ID = LINE_ID1
692: AND D.ITEM_ID = ITEM_ID1

Line 710: OP_CUST_MST V,

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
713: AND D.LINE_ID = LINE_ID1
714: AND D.ITEM_ID = ITEM_ID1