VIEW: APPS.CST_XLA_INV_REQ_V

Source

View Text - Preformatted

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME, MMT.PRIMARY_QUANTITY, MMT.SUBINVENTORY_CODE, CCG.COST_GROUP, MP.ORGANIZATION_CODE, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE, OEL.ORIG_SYS_DOCUMENT_REF REQ_NUMBER, MMT.TRANSACTION_DATE, MTR.REASON_NAME, MMT.TRANSACTION_REFERENCE, MMT.TRANSACTION_ID, MMT.TRANSACTION_SOURCE_TYPE_ID, MMT.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, OE_ORDER_LINES_ALL OEL WHERE 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.ORGANIZATION_ID = NVL(CCG.ORGANIZATION_ID,MMT.ORGANIZATION_ID) AND MMT.TRX_SOURCE_LINE_ID = OEL.LINE_ID

View Text - HTML Formatted

SELECT MSIK.CONCATENATED_SEGMENTS ITEM_NAME
, MMT.PRIMARY_QUANTITY
, MMT.SUBINVENTORY_CODE
, CCG.COST_GROUP
, MP.ORGANIZATION_CODE
, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE
, OEL.ORIG_SYS_DOCUMENT_REF REQ_NUMBER
, MMT.TRANSACTION_DATE
, MTR.REASON_NAME
, MMT.TRANSACTION_REFERENCE
, MMT.TRANSACTION_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MMT.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
, OE_ORDER_LINES_ALL OEL
WHERE 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.ORGANIZATION_ID = NVL(CCG.ORGANIZATION_ID
, MMT.ORGANIZATION_ID)
AND MMT.TRX_SOURCE_LINE_ID = OEL.LINE_ID