DBA Data[Home] [Help]

APPS.GML_ORAKRP_XMLP_PKG dependencies on OP_CHRG_MST

Line 14: OP_CHRG_MST CHRGMST,

10: CHRGMST.CHARGE_DESC,
11: ORDRCHG.EXTENDED_AMOUNT
12: INTO FLD1,FLD2
13: FROM
14: OP_CHRG_MST CHRGMST,
15: OP_ORDR_CHG ORDRCHG
16: WHERE ORDRCHG.LINE_ID = LINE_ID
17: AND CHRGMST.CHARGE_ID = ORDRCHG.CHARGE_ID
18: AND ORDRCHG.ORDER_ID = ORDER_ID

Line 116: OP_CHRG_MST CHRGMST,

112: DISTINCT
113: ORDRCHG.EXTENDED_AMOUNT
114: INTO EXT_AMT
115: FROM
116: OP_CHRG_MST CHRGMST,
117: OP_ORDR_CHG ORDRCHG
118: WHERE CHRGMST.CHARGE_ID = ORDRCHG.CHARGE_ID
119: AND ORDRCHG.DELETE_MARK = 0
120: AND ORDRCHG.BILLABLE_IND = 1