VIEW: APPS.CST_XLA_WIP_V

Source

View Text - Preformatted

SELECT DISTINCT WE.WIP_ENTITY_NAME WIP_ENTITY, NVL(MSIK_WT.CONCATENATED_SEGMENTS, MSIK_WE.CONCATENATED_SEGMENTS) ASSEMBLY_NAME, BR.RESOURCE_CODE RESOURCE_CODE, WT.PRIMARY_QUANTITY, MP.ORGANIZATION_CODE, BD.DEPARTMENT_CODE, WT.OPERATION_SEQ_NUM OPERATION_SEQ_NUM, WT.TRANSACTION_DATE, LU.MEANING BASIS_TYPE, MTR.REASON_NAME, WT.TRANSACTION_ID, NVL(WTA.RESOURCE_ID,-1), NVL(WTA.BASIS_TYPE,-1) BASIS_TYPE_ID FROM WIP_TRANSACTIONS WT, WIP_TRANSACTION_ACCOUNTS WTA, WIP_ENTITIES WE, BOM_RESOURCES BR, BOM_DEPARTMENTS BD, MTL_SYSTEM_ITEMS_KFV MSIK_WT, MTL_SYSTEM_ITEMS_KFV MSIK_WE, MTL_PARAMETERS MP, MTL_TRANSACTION_REASONS MTR, MFG_LOOKUPS LU WHERE WTA.RESOURCE_ID = BR.RESOURCE_ID (+) AND WT.ORGANIZATION_ID = NVL(BR.ORGANIZATION_ID, WT.ORGANIZATION_ID) AND WT.DEPARTMENT_ID = BD.DEPARTMENT_ID (+) AND WT.ORGANIZATION_ID = NVL(BD.ORGANIZATION_ID, WT.ORGANIZATION_ID) AND WT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND WT.ORGANIZATION_ID = MP.ORGANIZATION_ID AND WT.TRANSACTION_ID = WTA.TRANSACTION_ID AND WT.REASON_ID = MTR.REASON_ID (+) AND WT.PRIMARY_ITEM_ID = MSIK_WT.INVENTORY_ITEM_ID (+) AND WT.ORGANIZATION_ID = MSIK_WT.ORGANIZATION_ID (+) AND WE.PRIMARY_ITEM_ID = MSIK_WE.INVENTORY_ITEM_ID (+) AND WE.ORGANIZATION_ID = MSIK_WE.ORGANIZATION_ID (+) AND WTA.BASIS_TYPE = LU.LOOKUP_CODE (+) AND LU.LOOKUP_TYPE (+) = 'CST_BASIS'

View Text - HTML Formatted

SELECT DISTINCT WE.WIP_ENTITY_NAME WIP_ENTITY
, NVL(MSIK_WT.CONCATENATED_SEGMENTS
, MSIK_WE.CONCATENATED_SEGMENTS) ASSEMBLY_NAME
, BR.RESOURCE_CODE RESOURCE_CODE
, WT.PRIMARY_QUANTITY
, MP.ORGANIZATION_CODE
, BD.DEPARTMENT_CODE
, WT.OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, WT.TRANSACTION_DATE
, LU.MEANING BASIS_TYPE
, MTR.REASON_NAME
, WT.TRANSACTION_ID
, NVL(WTA.RESOURCE_ID
, -1)
, NVL(WTA.BASIS_TYPE
, -1) BASIS_TYPE_ID
FROM WIP_TRANSACTIONS WT
, WIP_TRANSACTION_ACCOUNTS WTA
, WIP_ENTITIES WE
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, MTL_SYSTEM_ITEMS_KFV MSIK_WT
, MTL_SYSTEM_ITEMS_KFV MSIK_WE
, MTL_PARAMETERS MP
, MTL_TRANSACTION_REASONS MTR
, MFG_LOOKUPS LU
WHERE WTA.RESOURCE_ID = BR.RESOURCE_ID (+)
AND WT.ORGANIZATION_ID = NVL(BR.ORGANIZATION_ID
, WT.ORGANIZATION_ID)
AND WT.DEPARTMENT_ID = BD.DEPARTMENT_ID (+)
AND WT.ORGANIZATION_ID = NVL(BD.ORGANIZATION_ID
, WT.ORGANIZATION_ID)
AND WT.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WT.TRANSACTION_ID = WTA.TRANSACTION_ID
AND WT.REASON_ID = MTR.REASON_ID (+)
AND WT.PRIMARY_ITEM_ID = MSIK_WT.INVENTORY_ITEM_ID (+)
AND WT.ORGANIZATION_ID = MSIK_WT.ORGANIZATION_ID (+)
AND WE.PRIMARY_ITEM_ID = MSIK_WE.INVENTORY_ITEM_ID (+)
AND WE.ORGANIZATION_ID = MSIK_WE.ORGANIZATION_ID (+)
AND WTA.BASIS_TYPE = LU.LOOKUP_CODE (+)
AND LU.LOOKUP_TYPE (+) = 'CST_BASIS'