APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on BOM_CTO_MLSUPPLY_FLOW_TEMP

Line 1583: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP

1579:
1580:
1581:
1582: l_stmt_num := 120;
1583: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP
1584: ( order_line_id,
1585: item_index,
1586: schedule_number,
1587: wip_entity_id,

Line 1815: FROM bom_cto_mlsupply_flow_temp

1811: schedule_number,
1812: scheduled_start_date,
1813: scheduled_completion_date,
1814: synch_schedule_num
1815: FROM bom_cto_mlsupply_flow_temp
1816: WHERE order_line_id = l_order_line_id
1817: order by item_index,scheduled_completion_date,schedule_number;
1818:
1819:

Line 2233: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP

2229: l_mlsupply_items(1).flow_end_index := l_flow_sch_details.last;
2230:
2231:
2232: l_stmt_num := 170;
2233: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP
2234: ( order_line_id,
2235: item_index,
2236: schedule_number,
2237: wip_entity_id,

Line 2803: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2799:
2800: l_stmt_num := 220;
2801: SELECT max(scheduled_completion_date)
2802: into max_completion_date
2803: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2804: where item_index = l_mlsupply_items(l_index).parent_index
2805: and order_line_id = p_Top_Assembly_LineId ;
2806:
2807: oe_debug_pub.add('aparameters for feeder call');

Line 2831: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP (

2827:
2828: END IF ;--parent feeder flag
2829:
2830: l_stmt_num := 240;
2831: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP (
2832: order_line_id,
2833: item_index,
2834: schedule_number,
2835: wip_entity_id,

Line 2858: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2854: FROM wip_flow_schedules
2855: where primary_item_id = l_mlsupply_items(l_index).item_id
2856: and synch_schedule_num in
2857: ( Select schedule_number
2858: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2859: where item_index = l_mlsupply_items(l_index).parent_index
2860: and order_line_id = p_Top_Assembly_LineId
2861: );
2862: ELSE--child is wip/buy/IR

Line 2894: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2890: IF l_operation_seq_id = -99 THEN --bugfix 2765109
2891: l_stmt_num := 2421;
2892: SELECT min(scheduled_start_date)
2893: into l_child_operation_date
2894: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2895: where item_index = l_mlsupply_items(l_index).parent_index;
2896:
2897: IF PG_DEBUG <> 0 THEN
2898:

Line 2914: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2910:
2911: l_stmt_num := 241;
2912: SELECT min(scheduled_completion_date)
2913: into l_min_completion_date
2914: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2915: where item_index = l_mlsupply_items(l_index).parent_index;
2916:
2917: IF PG_DEBUG <> 0 THEN
2918: oe_debug_pub.add ('create_subassembly_jobs: ' || 'min schedule date' || to_char(l_min_completion_date,'mm/dd/yy hh:mi:ss') ,1);