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_ORDR_DTL

Line 53: OP_ORDR_DTL D,

49: H.ORDER_NO
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

Line 96: OP_ORDR_DTL D,

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

Line 118: OP_ORDR_DTL D,

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

Line 287: OP_ORDR_DTL D,

283: V.CUST_NO
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

Line 330: OP_ORDR_DTL D,

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

Line 352: OP_ORDR_DTL D,

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

Line 406: OP_ORDR_DTL D,

402: D.FRTBILL_MTHD
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

Line 449: OP_ORDR_DTL D,

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

Line 471: OP_ORDR_DTL D,

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

Line 525: OP_ORDR_DTL D,

521: D.SHIP_MTHD
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

Line 568: OP_ORDR_DTL D,

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

Line 590: OP_ORDR_DTL D,

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

Line 644: OP_ORDR_DTL D,

640: S.SHIPPER_NAME
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

Line 687: OP_ORDR_DTL D,

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

Line 709: OP_ORDR_DTL D,

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