View: CST_XLA_WIP_V

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

View Text

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'

Columns