DBA Data[Home] [Help]

APPS.GMI_ICR03_XMLP_PKG dependencies on OP_ORDR_HDR

Line 52: OP_ORDR_HDR H,

48: SELECT
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

Line 286: OP_ORDR_HDR H,

282: SELECT
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

Line 405: OP_ORDR_HDR H,

401: SELECT
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

Line 524: OP_ORDR_HDR H,

520: SELECT
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

Line 643: OP_ORDR_HDR H,

639: SELECT
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