APPS.CSP_REQUIREMENT_POPULATE_PVT dependencies on CSP_TASK_PARTS_V

Line 63: FROM CSP_TASK_PARTS_V

59:
60:
61: CURSOR get_parts(temp_product_task_id NUMBER) IS
62: SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE
63: FROM CSP_TASK_PARTS_V
64: WHERE PRODUCT_TASK_ID = temp_product_task_id;*/
65:
66: CURSOR get_parts(temp_product_task_id NUMBER) IS
67: SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE,MANUAL_QUANTITY,ROLLUP_QUANTITY,REVISION

Line 68: FROM CSP_TASK_PARTS_V

64: WHERE PRODUCT_TASK_ID = temp_product_task_id;*/
65:
66: CURSOR get_parts(temp_product_task_id NUMBER) IS
67: SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE,MANUAL_QUANTITY,ROLLUP_QUANTITY,REVISION
68: FROM CSP_TASK_PARTS_V
69: WHERE PRODUCT_TASK_ID = temp_product_task_id
70: AND INVENTORY_ITEM_FLAG = 'Y'
71: AND NVL( trunc(START_DATE),trunc(sysdate)) <= trunc(sysdate)
72: AND NVL( trunc(END_DATE),trunc(sysdate+1)) >= trunc(sysdate);