VIEW: APPS.CST_XLA_INV_RCPT_V

Source

View Text - Preformatted

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME, DECODE(MP.primary_cost_method, 1, DECODE(MP_TFR.primary_cost_method, 1, DECODE(MP_TFR.process_enabled_flag, 'Y', MMT.primary_quantity, -1 * MMT.PRIMARY_QUANTITY ), MMT.primary_quantity ), MMT.primary_quantity) primary_quantity, DECODE(MP.primary_cost_method, 1, DECODE(MP_TFR.primary_cost_method, 1, DECODE(MP_TFR.process_enabled_flag, 'Y', MMT.subinventory_code, MMT.transfer_subinventory ), MMT.subinventory_code ), MMT.subinventory_code) SUBINVENTORY_CODE, CCG.COST_GROUP, DECODE(MP.primary_cost_method, 1, DECODE(MP_TFR.primary_cost_method, 1, DECODE(MP_TFR.process_enabled_flag, 'Y', MP.organization_code, MP_TFR.organization_code ), MP.organization_code ), MP.organization_code) ORGANIZATION_CODE, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE, MMT.TRANSACTION_DATE, MTR.REASON_NAME, MMT.TRANSACTION_REFERENCE, MMT.TRANSACTION_ID, MMT.TRANSACTION_SOURCE_TYPE_ID, DECODE(MP.primary_cost_method, 1, DECODE(MP_TFR.primary_cost_method, 1, DECODE(MP_TFR.process_enabled_flag, 'Y', MMT.organization_id, MMT.transfer_organization_id ), MMT.organization_id ), MMT.organization_id) ORGANIZATION_ID FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_PARAMETERS MP, MTL_PARAMETERS MP_TFR, MTL_SYSTEM_ITEMS_KFV MSIK, MTL_TRANSACTION_TYPES MTT, MTL_TRANSACTION_REASONS MTR, CST_COST_GROUPS CCG WHERE MMT.TRANSFER_ORGANIZATION_ID = MP_TFR.ORGANIZATION_ID AND MMT.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MMT.ORGANIZATION_ID = MSIK.ORGANIZATION_ID AND MMT.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID AND MTR.REASON_ID (+)= MMT.REASON_ID AND CCG.COST_GROUP_ID = DECODE(MP_TFR.primary_cost_method, 1, DECODE(MP.primary_cost_method, 1, DECODE(MP_TFR.process_enabled_flag, 'Y', MMT.cost_group_id, MMT.transfer_cost_group_id ), MMT.cost_group_id ), MMT.cost_group_id)

View Text - HTML Formatted

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MMT.PRIMARY_QUANTITY
, -1 * MMT.PRIMARY_QUANTITY )
, MMT.PRIMARY_QUANTITY )
, MMT.PRIMARY_QUANTITY) PRIMARY_QUANTITY
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MMT.SUBINVENTORY_CODE
, MMT.TRANSFER_SUBINVENTORY )
, MMT.SUBINVENTORY_CODE )
, MMT.SUBINVENTORY_CODE) SUBINVENTORY_CODE
, CCG.COST_GROUP
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MP.ORGANIZATION_CODE
, MP_TFR.ORGANIZATION_CODE )
, MP.ORGANIZATION_CODE )
, MP.ORGANIZATION_CODE) ORGANIZATION_CODE
, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE
, MMT.TRANSACTION_DATE
, MTR.REASON_NAME
, MMT.TRANSACTION_REFERENCE
, MMT.TRANSACTION_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MMT.ORGANIZATION_ID
, MMT.TRANSFER_ORGANIZATION_ID )
, MMT.ORGANIZATION_ID )
, MMT.ORGANIZATION_ID) ORGANIZATION_ID
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_PARAMETERS MP
, MTL_PARAMETERS MP_TFR
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_TRANSACTION_TYPES MTT
, MTL_TRANSACTION_REASONS MTR
, CST_COST_GROUPS CCG
WHERE MMT.TRANSFER_ORGANIZATION_ID = MP_TFR.ORGANIZATION_ID
AND MMT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MMT.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MMT.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND MTR.REASON_ID (+)= MMT.REASON_ID
AND CCG.COST_GROUP_ID = DECODE(MP_TFR.PRIMARY_COST_METHOD
, 1
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MMT.COST_GROUP_ID
, MMT.TRANSFER_COST_GROUP_ID )
, MMT.COST_GROUP_ID )
, MMT.COST_GROUP_ID)