VIEW: APPS.CSP_PRODUCT_TASKS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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