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 1803: FROM bom_cto_mlsupply_main_temp bcmm,

1799: CURSOR c_order_details
1800: IS
1801: SELECT DISTINCT(bcmm.order_line_id) order_line_id,
1802: oeh.order_number order_number
1803: FROM bom_cto_mlsupply_main_temp bcmm,
1804: oe_order_lines_all oel,
1805: oe_order_headers_all oeh
1806: WHERE bcmm.order_line_id = oel.line_id
1807: AND oel.header_id = oeh.header_id

Line 1825: FROM bom_cto_mlsupply_main_temp

1821: JOB_COMPLETION_DATE,
1822: SOURCE_TYPE,
1823: CFM_ROUTING_FLAG,
1824: comments
1825: FROM bom_cto_mlsupply_main_temp
1826: WHERE order_line_id = p_order_line_id
1827: ORDER BY item_index;
1828:
1829: CURSOR c_flow_supply(p_order_line_id IN NUMBER)

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

2276:
2277:
2278:
2279:
2280: --Insert for top most parent into BOM_CTO_MLSUPPLY_MAIN_TEMP table
2281: l_stmt_num := 180;
2282:
2283: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP
2284: ( order_line_id,

Line 2283: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP

2279:
2280: --Insert for top most parent into BOM_CTO_MLSUPPLY_MAIN_TEMP table
2281: l_stmt_num := 180;
2282:
2283: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP
2284: ( order_line_id,
2285: item_index ,
2286: item_id,
2287: item_name,

Line 2396: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP

2392: l_mlsupply_items(l_index).order_line_id := p_Top_Assembly_LineId;
2393:
2394: --insert data into MAIN table
2395:
2396: INSERT INTO BOM_CTO_MLSUPPLY_MAIN_TEMP
2397: ( order_line_id,
2398: item_index ,
2399: PARENT_INDEX,
2400: item_id,

Line 2453: from BOM_CTO_MLSUPPLY_MAIN_TEMP

2449: END IF;
2450:
2451: BEGIN
2452: select 'Y' INTO l_phantom
2453: from BOM_CTO_MLSUPPLY_MAIN_TEMP
2454: where wip_supply_type = 6
2455: and rownum = 1;
2456: Exception
2457: when no_data_found then

Line 2577: update bom_cto_mlsupply_main_temp

2573:
2574:
2575: --update parent items job start date
2576: l_stmt_num := 300;
2577: update bom_cto_mlsupply_main_temp
2578: set job_start_date = l_mlsupply_items(l_mlsupply_items(l_index).parent_index).job_start_date
2579: where item_index = l_mlsupply_items(l_index).parent_index
2580: and order_line_id = p_Top_Assembly_LineId ;
2581:

Line 2740: update bom_cto_mlsupply_main_temp

2736: END IF; --buy item
2737:
2738: END IF; -- end if parent start date is after sysdate
2739:
2740: update bom_cto_mlsupply_main_temp
2741: set job_completion_date = l_mlsupply_items(l_index).job_completion_date,
2742: job_start_date = l_mlsupply_items(l_index).job_start_date -- could be null value
2743: where item_index = l_index
2744: and order_line_id = p_Top_Assembly_LineId ;

Line 3032: update bom_cto_mlsupply_main_temp

3028:
3029:
3030: END IF;
3031:
3032: update bom_cto_mlsupply_main_temp
3033: set job_completion_date = l_mlsupply_items(l_index).job_completion_date
3034: where item_index = l_index
3035: and order_line_id = p_Top_Assembly_LineId;
3036:

Line 3063: update bom_cto_mlsupply_main_temp

3059:
3060: l_mlsupply_items(l_index).job_completion_date := SYSDATE;
3061: l_mlsupply_items(l_index).job_start_date := SYSDATE;
3062:
3063: update bom_cto_mlsupply_main_temp
3064: set job_completion_date = l_mlsupply_items(l_index).job_completion_date,
3065: job_start_date = l_mlsupply_items(l_index).job_start_date
3066: where item_index = l_index
3067: and order_line_id = p_Top_Assembly_LineId;

Line 3132: update bom_cto_mlsupply_main_temp

3128:
3129:
3130: END IF; --top most item is flow
3131:
3132: update bom_cto_mlsupply_main_temp
3133: set job_completion_date = l_mlsupply_items(l_index).job_completion_date,
3134: job_start_date = l_mlsupply_items(l_index).job_start_date
3135: where item_index = l_index
3136: and order_line_id = p_Top_Assembly_LineId;

Line 3147: update bom_cto_mlsupply_main_temp

3143:
3144:
3145: oe_debug_pub.add('create_subassembly_jobs: ' || 'DISCRETE job comp date is '|| l_mlsupply_items(l_index).job_completion_date,1);
3146:
3147: update bom_cto_mlsupply_main_temp
3148: set job_completion_date = l_mlsupply_items(l_index).job_completion_date
3149: where item_index = l_index
3150: and order_line_id = p_Top_Assembly_LineId;
3151:

Line 3845: update BOM_CTO_MLSUPPLY_MAIN_TEMP

3841: --removing phatom from chain
3842: pitems_table(m_index).parent_index := pitems_table(l_phantom_idx).parent_index;
3843:
3844: l_stmt_num := 20;
3845: update BOM_CTO_MLSUPPLY_MAIN_TEMP
3846: set actual_parent_index = pitems_table(m_index).actual_parent_idx,
3847: parent_index = pitems_table(m_index).parent_index
3848: where ITEM_INDEX = m_index;
3849:

Line 3898: update BOM_CTO_MLSUPPLY_MAIN_TEMP

3894:
3895: pitems_table(l_index).OPERATION_LEAD_TIME_PERCENT := pitems_table(l_actual_parent_idx).OPERATION_LEAD_TIME_PERCENT;
3896:
3897: l_stmt_num := 50;
3898: update BOM_CTO_MLSUPPLY_MAIN_TEMP
3899: set operation_seq_num = pitems_table(l_index).operation_seq_num,
3900: OPERATION_LEAD_TIME_PERCENT = pitems_table(l_index).OPERATION_LEAD_TIME_PERCENT
3901: where ITEM_INDEX = l_index;
3902:

Line 3961: update BOM_CTO_MLSUPPLY_MAIN_TEMP

3957: oe_debug_pub.add('process_phantoms:lead_time=>'||pitems_table(l_index).operation_lead_time_percent,1);
3958: END IF;
3959:
3960: l_stmt_num := 80;
3961: update BOM_CTO_MLSUPPLY_MAIN_TEMP
3962: set --operation_seq_num = pitems_table(l_index).operation_seq_num,
3963: OPERATION_LEAD_TIME_PERCENT = pitems_table(l_index).OPERATION_LEAD_TIME_PERCENT
3964: where ITEM_INDEX = l_index;
3965:

Line 4013: FROM BOM_CTO_MLSUPPLY_MAIN_TEMP

4009:
4010: l_stmt_num := 90;
4011: select min(OPERATION_SEQ_NUM),sum(needed_item_qty)
4012: into x_min_op_seq_num,l_cons_item_qty
4013: FROM BOM_CTO_MLSUPPLY_MAIN_TEMP
4014: WHERE parent_index = pitems_table(l_index).parent_index
4015: AND item_id = pitems_table(l_index).item_id;
4016:
4017: IF PG_DEBUG <> 0 THEN

Line 4025: Update bom_cto_mlsupply_main_temp

4021: oe_debug_pub.add('parent_index=>'||pitems_table(l_index).parent_index,5);
4022: END IF;
4023:
4024: l_stmt_num := 100;
4025: Update bom_cto_mlsupply_main_temp
4026: set needed_item_qty = 0
4027: where parent_index = pitems_table(l_index).parent_index
4028: AND item_id = pitems_table(l_index).item_id
4029: and Operation_seq_num <> x_min_op_seq_num;

Line 4033: Update bom_cto_mlsupply_main_temp

4029: and Operation_seq_num <> x_min_op_seq_num;
4030:
4031:
4032: l_stmt_num := 110;
4033: Update bom_cto_mlsupply_main_temp
4034: set needed_item_qty = l_cons_item_qty
4035: where parent_index = pitems_table(l_index).parent_index
4036: AND item_id = pitems_table(l_index).item_id
4037: and Operation_seq_num = x_min_op_seq_num;