View: GMF_XLA_PAYABLES_INVOICES_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from Payable Invoices
Implementation/DBA Data:	APPS.GMF_XLA_PAYABLES_INVOICES_V

View Text

SELECT EH.LEGAL_ENTITY_ID
, EH.LEDGER_ID
, EH.TRANSACTION_ID
, EH.VALUATION_COST_TYPE_ID
, EH.VALUATION_COST_TYPE
, EH.EVENT_CLASS_CODE
, LE.NAME LEGAL_ENTITY_NAME
, MSI.CONCATENATED_SEGMENTS AS ITEM_NAME
, MSI.DESCRIPTION AS ITEM_DESCRIPTION
, MP.ORGANIZATION_CODE
, GID.ACCOUNTED_DATE
, EH.TRANSACTION_QUANTITY ||' '|| MSI.PRIMARY_UOM_CODE AS PRIMARY_QUANTITY
, EH.TRANSACTION_UOM
, MSI.PRIMARY_UOM_CODE
, MSI.SECONDARY_UOM_CODE
, GPS.CALENDAR_CODE
, GPS.PERIOD_CODE
, DECODE(GPS.PERIOD_STATUS
, 'O'
, 'OPEN'
, 'F'
, 'FROZEN'
, 'C'
, 'CLOSED') PERIOD_STATUS
, DECODE(GID.INVOICE_VARIANCE_TYPE
, 1
, GID.BASE_IPV_ADJ_AMOUNT
, 2
, GID.BASE_ERV_ADJ_AMOUNT
, 3
, GID.BASE_IPV_ADJ_AMOUNT
, 4
, GID.BASE_ERV_ADJ_AMOUNT) AMOUNT
, DECODE(GID.INVOICE_VARIANCE_TYPE
, 1
, 'INVOICE PRICE VARIANCE'
, 2
, 'EXCHANGE RATE VARIANCE'
, 3
, 'TAX INVOICE PRICE VARIANCE'
, 4
, 'TAX EXCHANGE RATE VARIANCE') VARIANCE_TYPE
FROM GMF_XLA_EXTRACT_HEADERS EH
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_B_KFV MSI
, GMF_INVOICE_DISTRIBUTIONS GID
, XLE_ENTITY_PROFILES LE
, GMF_PERIOD_STATUSES GPS
WHERE EH.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = EH.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = EH.INVENTORY_ITEM_ID
AND GID.DISTRIBUTION_ID = EH.TRANSACTION_ID
AND LE.LEGAL_ENTITY_ID = EH.LEGAL_ENTITY_ID
AND GPS.PERIOD_ID = GID.PERIOD_ID
AND EH.EVENT_CLASS_CODE = 'PAYABLES_INVOICE'

Columns