APPS.CSP_PROD_TASK_PARTS_HISTORY dependencies on CSP_TASK_PARTS

Line 94: from csp_task_parts ctp

90: ctp.quantity_used,
91: ctp.actual_times_used,
92: ctp.rollup_quantity_used,
93: ctp.rollup_times_used
94: from csp_task_parts ctp
95: where ctp.product_task_id = p_product_task_id
96: and ctp.inventory_item_id = p_inventory_item_id
97: and nvl(ctp.revision,'-') = nvl(p_revision,'-') ;
98: l_temp_item_id NUMBER;

Line 280: from csp_task_parts ctp,

276: ctp.inventory_item_id,
277: ctp.actual_times_used,
278: ctp.rollup_quantity_used,
279: ctp.rollup_times_used
280: from csp_task_parts ctp,
281: mtl_related_items_view mriv
282: where mriv.related_item_id = ctp.inventory_item_id
283: and mriv.organization_id = l_organization_id
284: and mriv.inventory_item_id = p_inventory_item_id

Line 415: from csp_task_parts ctp

411: cursor supersede_items is
412: select ctp.task_part_id,
413: ctp.rollup_quantity_used,
414: ctp.rollup_times_used
415: from csp_task_parts ctp
416: where ctp.product_task_id = p_product_task_id
417: and ctp.inventory_item_id = l_supersede_item
418: and ctp.rollup_quantity_used is not null
419: and sysdate between nvl(ctp.start_date,sysdate-1)

Line 619: csp_task_parts_pkg.insert_row(

615: l_task_part_id number := null;
616:
617: begin
618:
619: csp_task_parts_pkg.insert_row(
620: px_task_part_id => l_task_part_id,
621: p_product_task_id => p_product_task_id,
622: p_inventory_item_id => p_inventory_item_id,
623: p_manual_quantity => null,

Line 669: csp_task_parts_pkg.Update_Row(

665: p_substitute_item number) is
666:
667: BEGIN
668:
669: csp_task_parts_pkg.Update_Row(
670: p_TASK_PART_ID => p_task_part_id,
671: p_PRODUCT_TASK_ID => fnd_api.g_miss_num,
672: p_INVENTORY_ITEM_ID => fnd_api.g_miss_num,
673: p_MANUAL_QUANTITY => fnd_api.g_miss_num,