APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on BOM_CTO_MLSUPPLY_FLOW_TEMP

Line 1621: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP

1617:
1618:
1619:
1620: l_stmt_num := 120;
1621: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP
1622: ( order_line_id,
1623: item_index,
1624: schedule_number,
1625: wip_entity_id,

Line 1836: FROM bom_cto_mlsupply_flow_temp

1832: schedule_number,
1833: scheduled_start_date,
1834: scheduled_completion_date,
1835: synch_schedule_num
1836: FROM bom_cto_mlsupply_flow_temp
1837: WHERE order_line_id = p_order_line_id
1838: ORDER BY item_index,
1839: scheduled_completion_date,
1840: schedule_number;

Line 2241: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP

2237: l_mlsupply_items(1).flow_end_index := l_flow_sch_details.last;
2238:
2239:
2240: l_stmt_num := 170;
2241: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP
2242: ( order_line_id,
2243: item_index,
2244: schedule_number,
2245: wip_entity_id,

Line 2816: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2812:
2813: l_stmt_num := 220;
2814: SELECT max(scheduled_completion_date)
2815: into max_completion_date
2816: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2817: where item_index = l_mlsupply_items(l_index).parent_index
2818: and order_line_id = p_Top_Assembly_LineId ;
2819:
2820: oe_debug_pub.add('aparameters for feeder call');

Line 2844: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP (

2840:
2841: END IF ;--parent feeder flag
2842:
2843: l_stmt_num := 240;
2844: INSERT INTO BOM_CTO_MLSUPPLY_FLOW_TEMP (
2845: order_line_id,
2846: item_index,
2847: schedule_number,
2848: wip_entity_id,

Line 2871: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2867: FROM wip_flow_schedules
2868: where primary_item_id = l_mlsupply_items(l_index).item_id
2869: and synch_schedule_num in
2870: ( Select schedule_number
2871: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2872: where item_index = l_mlsupply_items(l_index).parent_index
2873: and order_line_id = p_Top_Assembly_LineId
2874: );
2875: ELSE--child is wip/buy/IR

Line 2907: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2903: IF l_operation_seq_id = -99 THEN --bugfix 2765109
2904: l_stmt_num := 2421;
2905: SELECT min(scheduled_start_date)
2906: into l_child_operation_date
2907: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2908: where item_index = l_mlsupply_items(l_index).parent_index;
2909:
2910: IF PG_DEBUG <> 0 THEN
2911:

Line 2927: from BOM_CTO_MLSUPPLY_FLOW_TEMP

2923:
2924: l_stmt_num := 241;
2925: SELECT min(scheduled_completion_date)
2926: into l_min_completion_date
2927: from BOM_CTO_MLSUPPLY_FLOW_TEMP
2928: where item_index = l_mlsupply_items(l_index).parent_index;
2929:
2930: IF PG_DEBUG <> 0 THEN
2931: oe_debug_pub.add ('create_subassembly_jobs: ' || 'min schedule date' || to_char(l_min_completion_date,'mm/dd/yy hh:mi:ss') ,1);