eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on BOM_CTO_MLSUPPLY_MAIN_TEMP

Line 1783: from bom_cto_mlsupply_main_temp bcmm,

1779: l_run_req_import_flag varchar2(1) := 'N';
1780:
1781: CURSOR c_order_details IS
1782: Select distinct(bcmm.order_line_id),oeh.order_number
1783: from bom_cto_mlsupply_main_temp bcmm,
1784: oe_order_lines_all oel,
1785: oe_order_headers_all oeh
1786: where bcmm.order_line_id = oel.line_id
1787: and oel.header_id = oeh.header_id

Line 1803: FROM bom_cto_mlsupply_main_temp

1799: JOB_COMPLETION_DATE,
1800: SOURCE_TYPE,
1801: CFM_ROUTING_FLAG,
1802: comments
1803: FROM bom_cto_mlsupply_main_temp
1804: WHERE order_line_id = l_order_line_id
1805: order by item_index;
1806:
1807:

Line 2272: --Insert for top most parent into BOM_CTO_MLSUPPLY_MAIN_TEMP table

2268:
2269:
2270:
2271:
2272: --Insert for top most parent into BOM_CTO_MLSUPPLY_MAIN_TEMP table
2273: l_stmt_num := 180;
2274:
2275: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP
2276: ( order_line_id,

Line 2275: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP

2271:
2272: --Insert for top most parent into BOM_CTO_MLSUPPLY_MAIN_TEMP table
2273: l_stmt_num := 180;
2274:
2275: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP
2276: ( order_line_id,
2277: item_index ,
2278: item_id,
2279: item_name,

Line 2383: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP

2379: l_mlsupply_items(l_index).order_line_id := p_Top_Assembly_LineId;
2380:
2381: --insert data into MAIN table
2382:
2383: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP
2384: ( order_line_id,
2385: item_index ,
2386: PARENT_INDEX,
2387: item_id,

Line 2440: from BOM_CTO_MLSUPPLY_MAIN_TEMP

2436: END IF;
2437:
2438: BEGIN
2439: select 'Y' INTO l_phantom
2440: from BOM_CTO_MLSUPPLY_MAIN_TEMP
2441: where wip_supply_type = 6
2442: and rownum = 1;
2443: Exception
2444: when no_data_found then

Line 2564: update bom_cto_mlsupply_main_temp

2560:
2561:
2562: --update parent items job start date
2563: l_stmt_num := 300;
2564: update bom_cto_mlsupply_main_temp
2565: set job_start_date = l_mlsupply_items(l_mlsupply_items(l_index).parent_index).job_start_date
2566: where item_index = l_mlsupply_items(l_index).parent_index
2567: and order_line_id = p_Top_Assembly_LineId ;
2568:

Line 2727: update bom_cto_mlsupply_main_temp

2723: END IF; --buy item
2724:
2725: END IF; -- end if parent start date is after sysdate
2726:
2727: update bom_cto_mlsupply_main_temp
2728: set job_completion_date = l_mlsupply_items(l_index).job_completion_date,
2729: job_start_date = l_mlsupply_items(l_index).job_start_date -- could be null value
2730: where item_index = l_index
2731: and order_line_id = p_Top_Assembly_LineId ;

Line 3019: update bom_cto_mlsupply_main_temp

3015:
3016:
3017: END IF;
3018:
3019: update bom_cto_mlsupply_main_temp
3020: set job_completion_date = l_mlsupply_items(l_index).job_completion_date
3021: where item_index = l_index
3022: and order_line_id = p_Top_Assembly_LineId;
3023:

Line 3050: update bom_cto_mlsupply_main_temp

3046:
3047: l_mlsupply_items(l_index).job_completion_date := SYSDATE;
3048: l_mlsupply_items(l_index).job_start_date := SYSDATE;
3049:
3050: update bom_cto_mlsupply_main_temp
3051: set job_completion_date = l_mlsupply_items(l_index).job_completion_date,
3052: job_start_date = l_mlsupply_items(l_index).job_start_date
3053: where item_index = l_index
3054: and order_line_id = p_Top_Assembly_LineId;

Line 3119: update bom_cto_mlsupply_main_temp

3115:
3116:
3117: END IF; --top most item is flow
3118:
3119: update bom_cto_mlsupply_main_temp
3120: set job_completion_date = l_mlsupply_items(l_index).job_completion_date,
3121: job_start_date = l_mlsupply_items(l_index).job_start_date
3122: where item_index = l_index
3123: and order_line_id = p_Top_Assembly_LineId;

Line 3134: update bom_cto_mlsupply_main_temp

3130:
3131:
3132: oe_debug_pub.add('create_subassembly_jobs: ' || 'DISCRETE job comp date is '|| l_mlsupply_items(l_index).job_completion_date,1);
3133:
3134: update bom_cto_mlsupply_main_temp
3135: set job_completion_date = l_mlsupply_items(l_index).job_completion_date
3136: where item_index = l_index
3137: and order_line_id = p_Top_Assembly_LineId;
3138:

Line 3813: update BOM_CTO_MLSUPPLY_MAIN_TEMP

3809: --removing phatom from chain
3810: pitems_table(m_index).parent_index := pitems_table(l_phantom_idx).parent_index;
3811:
3812: l_stmt_num := 20;
3813: update BOM_CTO_MLSUPPLY_MAIN_TEMP
3814: set actual_parent_index = pitems_table(m_index).actual_parent_idx,
3815: parent_index = pitems_table(m_index).parent_index
3816: where ITEM_INDEX = m_index;
3817:

Line 3866: update BOM_CTO_MLSUPPLY_MAIN_TEMP

3862:
3863: pitems_table(l_index).OPERATION_LEAD_TIME_PERCENT := pitems_table(l_actual_parent_idx).OPERATION_LEAD_TIME_PERCENT;
3864:
3865: l_stmt_num := 50;
3866: update BOM_CTO_MLSUPPLY_MAIN_TEMP
3867: set operation_seq_num = pitems_table(l_index).operation_seq_num,
3868: OPERATION_LEAD_TIME_PERCENT = pitems_table(l_index).OPERATION_LEAD_TIME_PERCENT
3869: where ITEM_INDEX = l_index;
3870:

Line 3921: update BOM_CTO_MLSUPPLY_MAIN_TEMP

3917: END;
3918:
3919: oe_debug_pub.add('lead_time=>'||pitems_table(l_index).operation_lead_time_percent,1);
3920: l_stmt_num := 80;
3921: update BOM_CTO_MLSUPPLY_MAIN_TEMP
3922: set --operation_seq_num = pitems_table(l_index).operation_seq_num,
3923: OPERATION_LEAD_TIME_PERCENT = pitems_table(l_index).OPERATION_LEAD_TIME_PERCENT
3924: where ITEM_INDEX = l_index;
3925:

Line 3973: FROM BOM_CTO_MLSUPPLY_MAIN_TEMP

3969:
3970: l_stmt_num := 90;
3971: select min(OPERATION_SEQ_NUM),sum(needed_item_qty)
3972: into x_min_op_seq_num,l_cons_item_qty
3973: FROM BOM_CTO_MLSUPPLY_MAIN_TEMP
3974: WHERE parent_index = pitems_table(l_index).parent_index
3975: AND item_id = pitems_table(l_index).item_id;
3976:
3977: IF PG_DEBUG <> 0 THEN

Line 3985: Update bom_cto_mlsupply_main_temp

3981: oe_debug_pub.add('parent_index=>'||pitems_table(l_index).parent_index,5);
3982: END IF;
3983:
3984: l_stmt_num := 100;
3985: Update bom_cto_mlsupply_main_temp
3986: set needed_item_qty = 0
3987: where parent_index = pitems_table(l_index).parent_index
3988: AND item_id = pitems_table(l_index).item_id
3989: and Operation_seq_num <> x_min_op_seq_num;

Line 3993: Update bom_cto_mlsupply_main_temp

3989: and Operation_seq_num <> x_min_op_seq_num;
3990:
3991:
3992: l_stmt_num := 110;
3993: Update bom_cto_mlsupply_main_temp
3994: set needed_item_qty = l_cons_item_qty
3995: where parent_index = pitems_table(l_index).parent_index
3996: AND item_id = pitems_table(l_index).item_id
3997: and Operation_seq_num = x_min_op_seq_num;