Product: | GMF - Process Manufacturing Financials |
---|---|
Description: | View for SLA ADR sources from Resource Transactions |
Implementation/DBA Data: | APPS.GMF_XLA_PM_RSRC_TXNS_V |
SELECT EH.REFERENCE_NO
, EH.LEDGER_ID
, EH.TRANSACTION_ID
, EH.EVENT_CLASS_CODE
, EH.OPERATING_UNIT
, EH.TRANSACTION_DATE
, EH.TRANSACTION_QUANTITY ||' '|| BSR.USAGE_UM PRIMARY_QUANTITY
, MSI.PRIMARY_UOM_CODE
, MSI.SECONDARY_UOM_CODE
, EH.TRANSACTION_UOM
, EH.VALUATION_COST_TYPE_ID
, EH.VALUATION_COST_TYPE
, EH.SOURCE_DOCUMENT_ID
, EH.SOURCE_LINE_ID
, EH.LEGAL_ENTITY_ID
, LE.NAME LEGAL_ENTITY_NAME
, EH.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, EH.ORGANIZATION_ID
, BH.BATCH_ID
, BH.BATCH_NO BATCH_NUMBER
, BH.ORGANIZATION_CODE
, BH.PLANT_CODE
, BH.BATCH_STATUS_DESC BATCH_STATUS
, BH.ACTUAL_START_DATE BATCH_ACTUAL_START_DT
, BH.ACTUAL_CMPLT_DATE BATCH_ACTUAL_CMPLT_DT
, BH.FORMULA_NO ||' / '|| BH.FORMULA_VERS FORMULA
, BH.FORMULA_DESC1 FORMULA_DESC
, BH.ROUTING_NO ||' / '|| BH.ROUTING_VERS ROUTING_NO
, BH.ROUTING_DESC ROUTING_DESC
, BH.RECIPE_NO ||' / '||BH.RECIPE_VERSION RECIPE_NO
, BH.RECIPE_DESCRIPTION RECIPE_DESC
, RT.RESOURCES RESOURCES
, RT.RESOURCE_USAGE ||' '|| BSR.USAGE_UM RESOURCE_USAGE
, BSR.COST_ANALYSIS_CODE
, BSR.USAGE_UM
, BSR.COST_CMPNTCLS_ID
, CCM.COST_CMPNTCLS_CODE
, CCM.COST_CMPNTCLS_DESC
FROM GMF_XLA_EXTRACT_HEADERS EH
, GME_RESOURCE_TXNS RT
, GME_BATCH_HEADER_VW BH
, GME_BATCH_STEP_RESOURCES BSR
, CM_CMPT_MST CCM
, MTL_SYSTEM_ITEMS_B_KFV MSI
, XLE_ENTITY_PROFILES LE
WHERE EH.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND EH.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND EH.LEGAL_ENTITY_ID = LE.LEGAL_ENTITY_ID
AND EH.TRANSACTION_ID = RT.POC_TRANS_ID
AND EH.SOURCE_DOCUMENT_ID = RT.DOC_ID
AND EH.SOURCE_LINE_ID = RT.LINE_ID
AND RT.DOC_TYPE = 'PROD'
AND EH.RESOURCES = RT.RESOURCES
AND BH.BATCH_ID = RT.DOC_ID
AND RT.LINE_ID = BSR.BATCHSTEP_RESOURCE_ID
AND BSR.COST_CMPNTCLS_ID = CCM.COST_CMPNTCLS_ID