VIEW: APPS.GMF_XLA_PAYABLES_INVOICES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'