eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CST_XLA_INV_XFR_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)