APPS.GML_ORAKRP_XMLP_PKG dependencies on OP_ORDR_CHG

Line 15: OP_ORDR_CHG ORDRCHG

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
19: AND ORDRCHG.DELETE_MARK = 0

Line 117: OP_ORDR_CHG ORDRCHG

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
121: AND ORDRCHG.LINE_ID = LINE_ID

Line 387: OP_ORDR_CHG C

383: NVL(SUM(EXTENDED_AMOUNT)
384: ,0)
385: INTO EXT_AMT
386: FROM
387: OP_ORDR_CHG C
388: WHERE C.ORDER_ID = ORDER_ID
389: AND C.LINE_ID = LINE_ID
390: AND C.DELETE_MARK = 0
391: AND C.EXTENDED_AMOUNT > 0;

Line 409: OP_ORDR_CHG C

405: NVL(ABS(SUM(EXTENDED_AMOUNT))
406: ,0)
407: INTO EXT_AMT
408: FROM
409: OP_ORDR_CHG C
410: WHERE C.ORDER_ID = ORDER_ID
411: AND C.LINE_ID = LINE_ID
412: AND C.DELETE_MARK = 0
413: AND C.EXTENDED_AMOUNT < 0;

Line 430: OP_ORDR_CHG C

426: NVL(SUM(EXTENDED_AMOUNT)
427: ,0)
428: INTO EXT_AMT
429: FROM
430: OP_ORDR_CHG C
431: WHERE C.ORDER_ID = ORDER_ID
432: AND C.LINE_ID IS NULL
433: AND C.DELETE_MARK = 0
434: AND C.EXTENDED_AMOUNT > 0;

Line 451: OP_ORDR_CHG C

447: NVL(ABS(SUM(EXTENDED_AMOUNT))
448: ,0)
449: INTO EXT_AMT
450: FROM
451: OP_ORDR_CHG C
452: WHERE C.ORDER_ID = ORDER_ID
453: AND C.LINE_ID IS NULL
454: AND C.DELETE_MARK = 0
455: AND C.EXTENDED_AMOUNT < 0;

Line 474: OP_ORDR_CHG C

470: NVL(SUM(EXTENDED_AMOUNT)
471: ,0)
472: INTO EXT_AMT_CHARGE
473: FROM
474: OP_ORDR_CHG C
475: WHERE C.ORDER_ID = ORD_TOT_FORMULA.ORDER_ID
476: AND C.DELETE_MARK = 0;
477: SELECT
478: NVL(SUM(EXTENDED_PRICE)