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_CONFIG_ITEM_PK dependencies on BOM_EXPLOSION_TEMP

Line 1803: from bom_explosion_temp bet,mtl_system_items_kfv msi

1799: bet.sort_order,
1800: bet.plan_level,
1801: bet.line_id,
1802: substrb(msi.concatenated_segments,1,50)
1803: from bom_explosion_temp bet,mtl_system_items_kfv msi
1804: where bet.group_id = xGrpId
1805: and bet.organization_id = msi.organization_id
1806: and bet.component_item_id = msi.inventory_item_id;
1807:

Line 1865: select bom_explosion_temp_s.nextval

1861: return(1);
1862: else
1863:
1864: /* End Bugfix 2047428 */
1865: select bom_explosion_temp_s.nextval
1866: into xGrpId
1867: from dual;
1868:
1869: -- bugfix 1902818: Added nvl to oel.component_sequence_id.

Line 1880: insert into bom_explosion_temp(

1876: -- If ordered UOM and primary UOM are same , the function
1877: -- returns the ordered quantity.
1878:
1879:
1880: insert into bom_explosion_temp(
1881: top_bill_sequence_id,
1882: bill_sequence_id,
1883: organization_id,
1884: sort_order,

Line 1940: insert into bom_explosion_temp(

1936:
1937: level_number := level_number + 1;
1938:
1939: lStmtNumber := 610;
1940: insert into bom_explosion_temp(
1941: top_bill_sequence_id,
1942: bill_sequence_id,
1943: organization_id,
1944: sort_order,

Line 1981: bom_explosion_temp bet,

1977: oel.line_id,
1978: xGrpId
1979: from
1980: oe_order_lines_all oel,
1981: bom_explosion_temp bet,
1982: mtl_system_items msi
1983: where oel.ato_line_id = pLineId
1984: and oel.line_id <> pLineId
1985: and oel.inventory_item_id = msi.inventory_item_id

Line 2020: bom_explosion_temp bet,

2016: oel.line_id,
2017: xGrpId
2018: from
2019: oe_order_lines_all oel,
2020: bom_explosion_temp bet,
2021: mtl_system_items msi,
2022: bom_bill_of_materials bbm,
2023: bom_inventory_components bic
2024: where oel.ato_line_id = pLineId

Line 2091: from mtl_system_items msi , bom_explosion_temp be

2087: begin
2088:
2089: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
2090: into v_msi_fixed_lead_time, v_msi_variable_lead_time
2091: from mtl_system_items msi , bom_explosion_temp be
2092: where be.organization_id = msi.organization_id
2093: and be.component_item_id = msi.inventory_item_id
2094: and be.line_id = pLineId
2095: and be.group_id = xGrpId; -- bugfix 1876997

Line 2132: insert into bom_explosion_temp(

2128: -- Bug 1985793 Selecting greater of sysdate and calendar date
2129: -- while checking for item effectivity so that planning will get
2130: -- components effective till sysdate.
2131: --apps performance bugfix 4905845, sql id 16103327
2132: insert into bom_explosion_temp(
2133: top_bill_sequence_id,
2134: bill_sequence_id,
2135: organization_id,
2136: sort_order,

Line 2185: bom_explosion_temp be

2181: bom_inventory_components bic,
2182: eng_revised_items eri,
2183: bom_bill_of_materials bom,
2184: mtl_parameters mp,
2185: bom_explosion_temp be
2186: where be.sort_order <> 3 -- 1288823
2187: and be.group_id = xGrpId
2188: and nvl(be.plan_level,0) = level_number
2189: and be.organization_id = bom.organization_id

Line 2373: select bom_explosion_temp_s.nextval

2369: END IF;
2370: return(1);
2371: else
2372:
2373: select bom_explosion_temp_s.nextval
2374: into xGrpId
2375: from dual;
2376:
2377:

Line 2379: insert into bom_explosion_temp(

2375: from dual;
2376:
2377:
2378: lStmtNumber := 600;
2379: insert into bom_explosion_temp(
2380: top_bill_sequence_id,
2381: bill_sequence_id,
2382: organization_id,
2383: sort_order,

Line 2438: insert into bom_explosion_temp(

2434:
2435: level_number := level_number + 1;
2436:
2437: lStmtNumber := 610;
2438: insert into bom_explosion_temp(
2439: top_bill_sequence_id,
2440: bill_sequence_id,
2441: organization_id,
2442: sort_order,

Line 2470: bom_explosion_temp bet,

2466: oel.line_id,
2467: xGrpId
2468: from
2469: oe_order_lines_all oel,
2470: bom_explosion_temp bet,
2471: mtl_system_items msi
2472: where oel.ato_line_id = pLineId
2473: and oel.line_id <> pLineId
2474: and oel.inventory_item_id = msi.inventory_item_id

Line 2503: from mtl_system_items msi , bom_explosion_temp be

2499: begin
2500:
2501: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
2502: into v_msi_fixed_lead_time, v_msi_variable_lead_time
2503: from mtl_system_items msi , bom_explosion_temp be
2504: where be.organization_id = msi.organization_id
2505: and be.component_item_id = msi.inventory_item_id
2506: and be.line_id = pLineId
2507: and be.group_id = xGrpId;

Line 2542: insert into bom_explosion_temp(

2538:
2539: lStmtNumber := 620;
2540: --apps perf bug#4905845,sql id 16103462
2541: --reduce comments to decrease shared memory
2542: insert into bom_explosion_temp(
2543: top_bill_sequence_id,
2544: bill_sequence_id,
2545: organization_id,
2546: sort_order,

Line 2592: bom_explosion_temp be

2588: bom_inventory_components bic,
2589: eng_revised_items eri,
2590: bom_bill_of_materials bom,
2591: mtl_parameters mp,
2592: bom_explosion_temp be
2593: where be.sort_order <> 3
2594: and be.group_id = xGrpId
2595: and nvl(be.plan_level,0) = level_number
2596: and be.organization_id = bom.organization_id

Line 2763: from bom_explosion_temp bet,mtl_system_items_kfv msi

2759: bet.sort_order,
2760: bet.plan_level,
2761: bet.line_id,
2762: substrb(msi.concatenated_segments,1,50)
2763: from bom_explosion_temp bet,mtl_system_items_kfv msi
2764: where bet.group_id = xGrpId
2765: and bet.organization_id = msi.organization_id
2766: and bet.component_item_id = msi.inventory_item_id;
2767:

Line 2817: select bom_explosion_temp_s.nextval

2813:
2814: else
2815:
2816: /* End Bugfix 2047428 */
2817: select bom_explosion_temp_s.nextval
2818: into lGroupid2
2819: from dual;
2820:
2821: select bom_explosion_temp_s.nextval

Line 2821: select bom_explosion_temp_s.nextval

2817: select bom_explosion_temp_s.nextval
2818: into lGroupid2
2819: from dual;
2820:
2821: select bom_explosion_temp_s.nextval
2822: into xGrpId
2823: from dual;
2824:
2825: lStmtNumber := 600;

Line 2830: -- use bom_explosion_temp table to store the ship set for later join

2826:
2827:
2828: i := p_ship_set.inventory_item_id.FIRST;
2829:
2830: -- use bom_explosion_temp table to store the ship set for later join
2831: while i is not null
2832: loop
2833: insert into bom_explosion_temp(
2834: top_bill_sequence_id,

Line 2833: insert into bom_explosion_temp(

2829:
2830: -- use bom_explosion_temp table to store the ship set for later join
2831: while i is not null
2832: loop
2833: insert into bom_explosion_temp(
2834: top_bill_sequence_id,
2835: bill_sequence_id,
2836: organization_id,
2837: component_item_id,

Line 2881: -- insert the top model into bom_explosion_temp

2877: end loop;
2878:
2879:
2880:
2881: -- insert the top model into bom_explosion_temp
2882: insert into bom_explosion_temp(
2883: top_bill_sequence_id,
2884: bill_sequence_id,
2885: organization_id,

Line 2882: insert into bom_explosion_temp(

2878:
2879:
2880:
2881: -- insert the top model into bom_explosion_temp
2882: insert into bom_explosion_temp(
2883: top_bill_sequence_id,
2884: bill_sequence_id,
2885: organization_id,
2886: sort_order,

Line 2934: insert into bom_explosion_temp(

2930:
2931: level_number := level_number + 1;
2932:
2933: lStmtNumber := 610;
2934: insert into bom_explosion_temp(
2935: top_bill_sequence_id,
2936: bill_sequence_id,
2937: organization_id,
2938: sort_order,

Line 2974: bom_explosion_temp bet,

2970: from
2971: bom_bill_of_materials bom,
2972: bom_inventory_components bic,
2973: mtl_system_items msi, -- bugfix 1998386
2974: bom_explosion_temp bet,
2975: bom_explosion_temp bet2 /* ship set */
2976: where bet.group_id = xGrpId
2977: and bet.plan_level = level_number -1
2978: and bic.component_item_id = msi.inventory_item_id -- bugfix 1998386

Line 2975: bom_explosion_temp bet2 /* ship set */

2971: bom_bill_of_materials bom,
2972: bom_inventory_components bic,
2973: mtl_system_items msi, -- bugfix 1998386
2974: bom_explosion_temp bet,
2975: bom_explosion_temp bet2 /* ship set */
2976: where bet.group_id = xGrpId
2977: and bet.plan_level = level_number -1
2978: and bic.component_item_id = msi.inventory_item_id -- bugfix 1998386
2979: and bet.component_item_id = bom.assembly_item_id

Line 3033: delete from bom_explosion_temp

3029: IF PG_DEBUG <> 0 THEN
3030: oe_debug_pub.add ('load_mandatory_components: ' || 'Group_id : '|| xGrpId, 2);
3031: END IF;
3032:
3033: delete from bom_explosion_temp
3034: where group_id = lGroupid2;
3035:
3036: /*
3037: ** BUG no 1288823, new query block added

Line 3043: from mtl_system_items msi , bom_explosion_temp be

3039:
3040: begin
3041: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
3042: into v_msi_fixed_lead_time, v_msi_variable_lead_time
3043: from mtl_system_items msi , bom_explosion_temp be
3044: where be.organization_id = msi.organization_id
3045: and be.component_item_id = msi.inventory_item_id
3046: and be.component_item_id = p_ship_set.inventory_item_id(p_model_index);
3047:

Line 3075: insert into bom_explosion_temp(

3071: -- Bug 1985793 Selecting greater of sysdate and calendar date
3072: -- while checking for item effectivity so that planning will get
3073: -- components effective till sysdate.
3074: --apps performance bug#4905845, sql id 16103671
3075: insert into bom_explosion_temp(
3076: top_bill_sequence_id,
3077: bill_sequence_id,
3078: organization_id,
3079: sort_order,

Line 3125: bom_explosion_temp be

3121: bom_inventory_components bic,
3122: eng_revised_items eri,
3123: bom_bill_of_materials bom,
3124: mtl_parameters mp,
3125: bom_explosion_temp be
3126: where be.sort_order <> 3
3127: and be.group_id = xGrpId
3128: and nvl(be.plan_level,0) = level_number
3129: and be.organization_id = bom.organization_id

Line 3297: select bom_explosion_temp_s.nextval

3293: END IF;
3294: return(1);
3295:
3296: else
3297: select bom_explosion_temp_s.nextval
3298: into lGroupid2
3299: from dual;
3300:
3301: select bom_explosion_temp_s.nextval

Line 3301: select bom_explosion_temp_s.nextval

3297: select bom_explosion_temp_s.nextval
3298: into lGroupid2
3299: from dual;
3300:
3301: select bom_explosion_temp_s.nextval
3302: into xGrpId
3303: from dual;
3304:
3305: lStmtNumber := 600;

Line 3310: -- use bom_explosion_temp table to store the ship set for later join

3306:
3307:
3308: i := p_ship_set.inventory_item_id.FIRST;
3309:
3310: -- use bom_explosion_temp table to store the ship set for later join
3311: while i is not null
3312: loop
3313: insert into bom_explosion_temp(
3314: top_bill_sequence_id,

Line 3313: insert into bom_explosion_temp(

3309:
3310: -- use bom_explosion_temp table to store the ship set for later join
3311: while i is not null
3312: loop
3313: insert into bom_explosion_temp(
3314: top_bill_sequence_id,
3315: bill_sequence_id,
3316: organization_id,
3317: component_item_id,

Line 3347: -- insert the top model into bom_explosion_temp

3343: end loop;
3344:
3345:
3346:
3347: -- insert the top model into bom_explosion_temp
3348: insert into bom_explosion_temp(
3349: top_bill_sequence_id,
3350: bill_sequence_id,
3351: organization_id,

Line 3348: insert into bom_explosion_temp(

3344:
3345:
3346:
3347: -- insert the top model into bom_explosion_temp
3348: insert into bom_explosion_temp(
3349: top_bill_sequence_id,
3350: bill_sequence_id,
3351: organization_id,
3352: sort_order,

Line 3393: insert into bom_explosion_temp(

3389:
3390: level_number := level_number + 1;
3391:
3392: lStmtNumber := 610;
3393: insert into bom_explosion_temp(
3394: top_bill_sequence_id,
3395: bill_sequence_id,
3396: organization_id,
3397: sort_order,

Line 3425: bom_explosion_temp bet,

3421: from
3422: bom_bill_of_materials bom,
3423: bom_inventory_components bic,
3424: mtl_system_items msi,
3425: bom_explosion_temp bet,
3426: bom_explosion_temp bet2
3427: where bet.group_id = xGrpId
3428: and bet.plan_level = level_number -1
3429: and bic.component_item_id = msi.inventory_item_id

Line 3426: bom_explosion_temp bet2

3422: bom_bill_of_materials bom,
3423: bom_inventory_components bic,
3424: mtl_system_items msi,
3425: bom_explosion_temp bet,
3426: bom_explosion_temp bet2
3427: where bet.group_id = xGrpId
3428: and bet.plan_level = level_number -1
3429: and bic.component_item_id = msi.inventory_item_id
3430: and msi.bom_item_type in ( 1, 2 ) /* Only Sub-models and Option Classes */

Line 3455: delete from bom_explosion_temp

3451: IF PG_DEBUG <> 0 THEN
3452: oe_debug_pub.add ('load_mandatory_components_pds: ' || 'Group_id : '|| xGrpId, 2);
3453: END IF;
3454:
3455: delete from bom_explosion_temp
3456: where group_id = lGroupid2;
3457:
3458: begin
3459: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)

Line 3461: from mtl_system_items msi , bom_explosion_temp be

3457:
3458: begin
3459: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
3460: into v_msi_fixed_lead_time, v_msi_variable_lead_time
3461: from mtl_system_items msi , bom_explosion_temp be
3462: where be.organization_id = msi.organization_id
3463: and be.component_item_id = msi.inventory_item_id
3464: and be.component_item_id = p_ship_set.inventory_item_id(p_model_index);
3465:

Line 3491: insert into bom_explosion_temp(

3487:
3488: lStmtNumber := 620;
3489: --appsperf bug#4905845, sql id 16103821
3490: --removed comments to reduce shared memory
3491: insert into bom_explosion_temp(
3492: top_bill_sequence_id,
3493: bill_sequence_id,
3494: organization_id,
3495: sort_order,

Line 3539: bom_explosion_temp be

3535: bom_inventory_components bic,
3536: eng_revised_items eri,
3537: bom_bill_of_materials bom,
3538: mtl_parameters mp,
3539: bom_explosion_temp be
3540: where be.sort_order <> 3
3541: and be.group_id = xGrpId
3542: and nvl(be.plan_level,0) = level_number
3543: and be.organization_id = bom.organization_id

Line 3679: from bom_explosion_temp be

3675: primary_uom_code uom, -- Bugfix 1998386
3676: plan_level pl,
3677: line_id, -- Bugfix 2897132
3678: wip_supply_type -- Bugfix 3254039
3679: from bom_explosion_temp be
3680: where be.group_id = lGrpId
3681: and ( be.line_id is null or top_bill_sequence_id = -1 ) -- Bugfix 2897132
3682: and be.sort_order <> 2 ;
3683: --BUG 1288823 modification to send restricted components to atp

Line 3950: from bom_explosion_temp

3946:
3947:
3948: select count(*)
3949: into chk
3950: from bom_explosion_temp
3951: where group_id = lGrpId
3952: and ( Line_id is null or top_bill_sequence_id = -1) ; /* BugFix 2897132 */
3953:
3954: IF PG_DEBUG <> 0 THEN

Line 4026: Clean up bom_explosion_temp table

4022: END IF;
4023:
4024:
4025: /*------------------------------------+
4026: Clean up bom_explosion_temp table
4027: +------------------------------------*/
4028: lStmtNumber := 750;
4029:
4030: delete from bom_explosion_temp

Line 4030: delete from bom_explosion_temp

4026: Clean up bom_explosion_temp table
4027: +------------------------------------*/
4028: lStmtNumber := 750;
4029:
4030: delete from bom_explosion_temp
4031: where group_id = lGrpId;
4032:
4033: return(1);
4034: