View: GML_GPOAO_DETAIL_CHARGES_V

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

View Text

SELECT OD.LINE_ID LINE_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_DTL OD
, OP_ORDR_CHG OC
, OP_CHRG_MST CM
WHERE OD.LINE_ID = OC.LINE_ID
AND OC.CHARGE_ID = CM.CHARGE_ID

Columns