Product: | CSP - Spares Management |
---|---|
Description: | Task Part Information |
Implementation/DBA Data: | APPS.CSP_TASK_PARTS_V |
SELECT CTP.TASK_PART_ID
, CTP.PRODUCT_TASK_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.ORGANIZATION_ID
, CTP.INVENTORY_ITEM_ID
, CTP.MANUAL_QUANTITY
, CTP.MANUAL_PERCENTAGE
, CTP.ROLLUP_QUANTITY_USED
, CTP.ROLLUP_TIMES_USED
, (CTP.ROLLUP_QUANTITY_USED/CTP.ROLLUP_TIMES_USED)
, ((CTP.ROLLUP_TIMES_USED/CPT.ACTUAL_TIMES_USED)*100)
, CTP.QUANTITY_USED
, CTP.ACTUAL_TIMES_USED
, (CTP.QUANTITY_USED/CTP.ACTUAL_TIMES_USED)
, ((CTP.ACTUAL_TIMES_USED/CPT.ACTUAL_TIMES_USED)*100)
, NVL(CTP.MANUAL_QUANTITY
, NVL(NVL((CTP.ROLLUP_QUANTITY_USED/CTP.ROLLUP_TIMES_USED)
, (CTP.QUANTITY_USED/CTP.ACTUAL_TIMES_USED))
, NULL))
, NVL(CTP.MANUAL_PERCENTAGE
, NVL( NVL((CTP.ROLLUP_TIMES_USED/CPT.ACTUAL_TIMES_USED)*100
, ((CTP.ACTUAL_TIMES_USED/CPT.ACTUAL_TIMES_USED)*100))
, NULL))
, CTP.PRIMARY_UOM_CODE
, CTP.REVISION
, CTP.START_DATE
, CTP.END_DATE
, CTP.SUBSTITUTE_ITEM
, CTP.CREATED_BY
, CTP.CREATION_DATE
, CTP.LAST_UPDATED_BY
, CTP.LAST_UPDATE_DATE
, CTP.LAST_UPDATE_LOGIN
, CTP.ATTRIBUTE_CATEGORY
, CTP.ATTRIBUTE1
, CTP.ATTRIBUTE2
, CTP.ATTRIBUTE3
, CTP.ATTRIBUTE4
, CTP.ATTRIBUTE5
, CTP.ATTRIBUTE6
, CTP.ATTRIBUTE7
, CTP.ATTRIBUTE8
, CTP.ATTRIBUTE9
, CTP.ATTRIBUTE10
, CTP.ATTRIBUTE11
, CTP.ATTRIBUTE12
, CTP.ATTRIBUTE13
, CTP.ATTRIBUTE14
, CTP.ATTRIBUTE15
FROM CSP_TASK_PARTS CTP
, CSP_PRODUCT_TASKS CPT
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE CPT.PRODUCT_TASK_ID = CTP.PRODUCT_TASK_ID
AND MSI.INVENTORY_ITEM_ID = CTP.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID