Product: | CSP - Spares Management |
---|---|
Description: | Product Task information |
Implementation/DBA Data: | APPS.CSP_PRODUCT_TASKS_V |
SELECT CPT.PRODUCT_TASK_ID
, CPT.PRODUCT_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.ORGANIZATION_ID
, CPT.TASK_TEMPLATE_ID
, CPT.AUTO_MANUAL
, CPT.ACTUAL_TIMES_USED
, CPT.TASK_PERCENTAGE
, JTF.TASK_NAME
, JTF.DESCRIPTION
, FND.MEANING
, CPT.ATTRIBUTE_CATEGORY
, CPT.ATTRIBUTE1
, CPT.ATTRIBUTE2
, CPT.ATTRIBUTE3
, CPT.ATTRIBUTE4
, CPT.ATTRIBUTE5
, CPT.ATTRIBUTE6
, CPT.ATTRIBUTE7
, CPT.ATTRIBUTE8
, CPT.ATTRIBUTE9
, CPT.ATTRIBUTE10
, CPT.ATTRIBUTE11
, CPT.ATTRIBUTE12
, CPT.ATTRIBUTE13
, CPT.ATTRIBUTE14
, CPT.ATTRIBUTE15
, CPT.CREATED_BY
, CPT.CREATION_DATE
, CPT.LAST_UPDATED_BY
, CPT.LAST_UPDATE_DATE
, CPT.LAST_UPDATE_LOGIN
FROM CSP_PRODUCT_TASKS CPT
, JTF_TASK_TEMPLATES_VL JTF
, FND_LOOKUPS FND
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE CPT.TASK_TEMPLATE_ID = JTF.TASK_TEMPLATE_ID
AND CPT.AUTO_MANUAL = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'CSP_PRODUCT_TASK'
AND MSI.INVENTORY_ITEM_ID = CPT.PRODUCT_ID
AND MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID