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.

VIEW: APPS.GML_GPOAO_ORDER_CHARGES_V

Source

View Text - Preformatted


SELECT oh.order_id ORDER_ID, decode(oc.billable_ind,0,0,1,1,1) SAC_INDICATOR_INT, cm.charge_code SAC_CODE_INT, cm.charge_type SAC_METHOD_INT, oc.charge_line_amount CHARGE_LINE_AMOUNT, oc.charge_rate CHARGE_RATE, oc.charge_unit_amount CHARGE_UNIT_AMOUNT, oc.charge_uom CHARGE_UOM, oc.charge_qty CHARGE_QTY, cm.charge_desc SAC_DESCRIPTION FROM op_ordr_hdr oh, op_ordr_chg oc, op_chrg_mst cm WHERE oh.order_id = oc.order_id AND nvl(oc.line_id,0) = 0 AND oc.charge_id = cm.charge_id

View Text - HTML Formatted

SELECT OH.ORDER_ID ORDER_ID
, DECODE(OC.BILLABLE_IND
, 0
, 0
, 1
, 1
, 1) SAC_INDICATOR_INT
, CM.CHARGE_CODE SAC_CODE_INT
, CM.CHARGE_TYPE SAC_METHOD_INT
, OC.CHARGE_LINE_AMOUNT CHARGE_LINE_AMOUNT
, OC.CHARGE_RATE CHARGE_RATE
, OC.CHARGE_UNIT_AMOUNT CHARGE_UNIT_AMOUNT
, OC.CHARGE_UOM CHARGE_UOM
, OC.CHARGE_QTY CHARGE_QTY
, CM.CHARGE_DESC SAC_DESCRIPTION
FROM OP_ORDR_HDR OH
, OP_ORDR_CHG OC
, OP_CHRG_MST CM
WHERE OH.ORDER_ID = OC.ORDER_ID
AND NVL(OC.LINE_ID
, 0) = 0
AND OC.CHARGE_ID = CM.CHARGE_ID