APPS.CSP_REQUIREMENT_POPULATE_PVT dependencies on CSP_TASK_PARTS_V

Line 47: FROM CSP_TASK_PARTS_V

43:
44:
45: CURSOR get_parts(temp_product_task_id NUMBER) IS
46: SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE
47: FROM CSP_TASK_PARTS_V
48: WHERE PRODUCT_TASK_ID = temp_product_task_id;*/
49:
50: CURSOR get_parts(temp_product_task_id NUMBER) IS
51: SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE,MANUAL_QUANTITY,ROLLUP_QUANTITY,REVISION

Line 52: FROM CSP_TASK_PARTS_V

48: WHERE PRODUCT_TASK_ID = temp_product_task_id;*/
49:
50: CURSOR get_parts(temp_product_task_id NUMBER) IS
51: SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE,MANUAL_QUANTITY,ROLLUP_QUANTITY,REVISION
52: FROM CSP_TASK_PARTS_V
53: WHERE PRODUCT_TASK_ID = temp_product_task_id
54: AND INVENTORY_ITEM_FLAG = 'Y'
55: AND NVL( trunc(START_DATE),trunc(sysdate)) <= trunc(sysdate)
56: AND NVL( trunc(END_DATE),trunc(sysdate+1)) >= trunc(sysdate);