View: GML_GPOAO_ORDER_CHARGES_V

Product:	GML - Process Manufacturing Logistics
Description:	Sales Order Header Charges view
Implementation/DBA Data:	APPS.GML_GPOAO_ORDER_CHARGES_V

View Text

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

Columns