View: CST_XLA_INV_XFR_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_INV_XFR_V

View Text

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MMT.PRIMARY_QUANTITY
, -1*MMT.PRIMARY_QUANTITY ) PRIMARY_QUANTITY
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MMT.SUBINVENTORY_CODE
, MMT.TRANSFER_SUBINVENTORY ) SUBINVENTORY_CODE
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, CCG.COST_GROUP
, CCG_TFR.COST_GROUP ) COST_GROUP
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MP.ORGANIZATION_CODE
, MP_TFR.ORGANIZATION_CODE) ORGANIZATION_CODE
, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE
, MMT.TRANSACTION_SOURCE_ID
, MMT.TRANSACTION_DATE
, MTR.REASON_NAME
, MMT.TRANSACTION_REFERENCE
, MMT.TRANSACTION_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, DECODE(MP_TFR.PROCESS_ENABLED_FLAG
, 'Y'
, MP.ORGANIZATION_ID
, MP_TFR.ORGANIZATION_ID) ORGANIZATION_ID
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_TRANSACTION_TYPES MTT
, MTL_TRANSACTION_REASONS MTR
, CST_COST_GROUPS CCG
, CST_COST_GROUPS CCG_TFR
, MTL_PARAMETERS MP_TFR
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 MMT.COST_GROUP_ID = CCG.COST_GROUP_ID
AND MMT.TRANSFER_COST_GROUP_ID = CCG_TFR.COST_GROUP_ID (+)

Columns