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 276: from csp_task_parts ctp,

272: ctp.inventory_item_id,
273: ctp.actual_times_used,
274: ctp.rollup_quantity_used,
275: ctp.rollup_times_used
276: from csp_task_parts ctp,
277: mtl_related_items_view mriv
278: where mriv.related_item_id = ctp.inventory_item_id
279: and mriv.organization_id = l_organization_id
280: and mriv.inventory_item_id = p_inventory_item_id

Line 411: from csp_task_parts ctp

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

Line 615: csp_task_parts_pkg.insert_row(

611: l_task_part_id number := null;
612:
613: begin
614:
615: csp_task_parts_pkg.insert_row(
616: px_task_part_id => l_task_part_id,
617: p_product_task_id => p_product_task_id,
618: p_inventory_item_id => p_inventory_item_id,
619: p_manual_quantity => null,

Line 665: csp_task_parts_pkg.Update_Row(

661: p_substitute_item number) is
662:
663: BEGIN
664:
665: csp_task_parts_pkg.Update_Row(
666: p_TASK_PART_ID => p_task_part_id,
667: p_PRODUCT_TASK_ID => fnd_api.g_miss_num,
668: p_INVENTORY_ITEM_ID => fnd_api.g_miss_num,
669: p_MANUAL_QUANTITY => fnd_api.g_miss_num,