[Home] [Help]
View: CST_XLA_OSP_V
View Text
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 (+)
Columns
Name |
WIP_ENTITY |
ASSEMBLY_NAME |
RESOURCE_CODE |
PRIMARY_QUANTITY |
ORGANIZATION_CODE |
DEPARTMENT_CODE |
OPERATION_SEQ_NUM |
TRANSACTION_DATE |
BASIS_TYPE |
PO_NUMBER |
TRANSACTION_ID |
RESOURCE_ID |
BASIS_TYPE_ID |