VIEW: APPS.CST_XLA_OSP_V

Source

View Text - Preformatted

SELECT DISTINCT WE.WIP_ENTITY_NAME WIP_ENTITY, MSIK.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, POH.SEGMENT1 PO_NUMBER, WT.TRANSACTION_ID, NVL(WTA.RESOURCE_ID, -1) RESOURCE_ID, 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, MTL_PARAMETERS MP, MTL_TRANSACTION_REASONS MTR, MFG_LOOKUPS LU, PO_HEADERS_ALL POH WHERE WTA.RESOURCE_ID = BR.RESOURCE_ID (+) AND WTA.ORGANIZATION_ID = BR.ORGANIZATION_ID (+) AND WT.DEPARTMENT_ID = BD.DEPARTMENT_ID (+) AND WT.ORGANIZATION_ID = BD.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 MTR.REASON_ID (+)= WT.REASON_ID AND WT.PRIMARY_ITEM_ID = MSIK.INVENTORY_ITEM_ID (+) AND WT.ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+) AND WTA.BASIS_TYPE = LU.LOOKUP_CODE (+) AND LU.LOOKUP_TYPE (+) = 'CST_BASIS' AND WT.PO_HEADER_ID = POH.PO_HEADER_ID (+)

View Text - HTML Formatted

SELECT DISTINCT WE.WIP_ENTITY_NAME WIP_ENTITY
, MSIK.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
, POH.SEGMENT1 PO_NUMBER
, WT.TRANSACTION_ID
, NVL(WTA.RESOURCE_ID
, -1) RESOURCE_ID
, 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
, MTL_PARAMETERS MP
, MTL_TRANSACTION_REASONS MTR
, MFG_LOOKUPS LU
, PO_HEADERS_ALL POH
WHERE WTA.RESOURCE_ID = BR.RESOURCE_ID (+)
AND WTA.ORGANIZATION_ID = BR.ORGANIZATION_ID (+)
AND WT.DEPARTMENT_ID = BD.DEPARTMENT_ID (+)
AND WT.ORGANIZATION_ID = BD.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 MTR.REASON_ID (+)= WT.REASON_ID
AND WT.PRIMARY_ITEM_ID = MSIK.INVENTORY_ITEM_ID (+)
AND WT.ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)
AND WTA.BASIS_TYPE = LU.LOOKUP_CODE (+)
AND LU.LOOKUP_TYPE (+) = 'CST_BASIS'
AND WT.PO_HEADER_ID = POH.PO_HEADER_ID (+)