VIEW: APPS.CSP_TASK_PARTS_V

Source

View Text - Preformatted

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, msi.inventory_item_flag, 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

View Text - HTML Formatted

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
, MSI.INVENTORY_ITEM_FLAG
, 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