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 1896: from bom_explosion_temp bet,mtl_system_items_kfv msi

1892: bet.sort_order,
1893: bet.plan_level,
1894: bet.line_id,
1895: substrb(msi.concatenated_segments,1,50)
1896: from bom_explosion_temp bet,mtl_system_items_kfv msi
1897: where bet.group_id = xGrpId
1898: and bet.organization_id = msi.organization_id
1899: and bet.component_item_id = msi.inventory_item_id;
1900:

Line 1958: select bom_explosion_temp_s.nextval

1954: return(1);
1955: else
1956:
1957: /* End Bugfix 2047428 */
1958: select bom_explosion_temp_s.nextval
1959: into xGrpId
1960: from dual;
1961:
1962: -- bugfix 1902818: Added nvl to oel.component_sequence_id.

Line 1973: insert into bom_explosion_temp(

1969: -- If ordered UOM and primary UOM are same , the function
1970: -- returns the ordered quantity.
1971:
1972:
1973: insert into bom_explosion_temp(
1974: top_bill_sequence_id,
1975: bill_sequence_id,
1976: organization_id,
1977: sort_order,

Line 2033: insert into bom_explosion_temp(

2029:
2030: level_number := level_number + 1;
2031:
2032: lStmtNumber := 610;
2033: insert into bom_explosion_temp(
2034: top_bill_sequence_id,
2035: bill_sequence_id,
2036: organization_id,
2037: sort_order,

Line 2074: bom_explosion_temp bet,

2070: oel.line_id,
2071: xGrpId
2072: from
2073: oe_order_lines_all oel,
2074: bom_explosion_temp bet,
2075: mtl_system_items msi
2076: where oel.ato_line_id = pLineId
2077: and oel.line_id <> pLineId
2078: and oel.inventory_item_id = msi.inventory_item_id

Line 2113: bom_explosion_temp bet,

2109: oel.line_id,
2110: xGrpId
2111: from
2112: oe_order_lines_all oel,
2113: bom_explosion_temp bet,
2114: mtl_system_items msi,
2115: bom_bill_of_materials bbm,
2116: bom_inventory_components bic
2117: where oel.ato_line_id = pLineId

Line 2184: from mtl_system_items msi , bom_explosion_temp be

2180: begin
2181:
2182: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
2183: into v_msi_fixed_lead_time, v_msi_variable_lead_time
2184: from mtl_system_items msi , bom_explosion_temp be
2185: where be.organization_id = msi.organization_id
2186: and be.component_item_id = msi.inventory_item_id
2187: and be.line_id = pLineId
2188: and be.group_id = xGrpId; -- bugfix 1876997

Line 2225: insert into bom_explosion_temp(

2221: -- Bug 1985793 Selecting greater of sysdate and calendar date
2222: -- while checking for item effectivity so that planning will get
2223: -- components effective till sysdate.
2224: --apps performance bugfix 4905845, sql id 16103327
2225: insert into bom_explosion_temp(
2226: top_bill_sequence_id,
2227: bill_sequence_id,
2228: organization_id,
2229: sort_order,

Line 2278: bom_explosion_temp be

2274: bom_inventory_components bic,
2275: eng_revised_items eri,
2276: bom_bill_of_materials bom,
2277: mtl_parameters mp,
2278: bom_explosion_temp be
2279: where be.sort_order <> 3 -- 1288823
2280: and be.group_id = xGrpId
2281: and nvl(be.plan_level,0) = level_number
2282: and be.organization_id = bom.organization_id

Line 2466: select bom_explosion_temp_s.nextval

2462: END IF;
2463: return(1);
2464: else
2465:
2466: select bom_explosion_temp_s.nextval
2467: into xGrpId
2468: from dual;
2469:
2470:

Line 2472: insert into bom_explosion_temp(

2468: from dual;
2469:
2470:
2471: lStmtNumber := 600;
2472: insert into bom_explosion_temp(
2473: top_bill_sequence_id,
2474: bill_sequence_id,
2475: organization_id,
2476: sort_order,

Line 2531: insert into bom_explosion_temp(

2527:
2528: level_number := level_number + 1;
2529:
2530: lStmtNumber := 610;
2531: insert into bom_explosion_temp(
2532: top_bill_sequence_id,
2533: bill_sequence_id,
2534: organization_id,
2535: sort_order,

Line 2563: bom_explosion_temp bet,

2559: oel.line_id,
2560: xGrpId
2561: from
2562: oe_order_lines_all oel,
2563: bom_explosion_temp bet,
2564: mtl_system_items msi
2565: where oel.ato_line_id = pLineId
2566: and oel.line_id <> pLineId
2567: and oel.inventory_item_id = msi.inventory_item_id

Line 2596: from mtl_system_items msi , bom_explosion_temp be

2592: begin
2593:
2594: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
2595: into v_msi_fixed_lead_time, v_msi_variable_lead_time
2596: from mtl_system_items msi , bom_explosion_temp be
2597: where be.organization_id = msi.organization_id
2598: and be.component_item_id = msi.inventory_item_id
2599: and be.line_id = pLineId
2600: and be.group_id = xGrpId;

Line 2635: insert into bom_explosion_temp(

2631:
2632: lStmtNumber := 620;
2633: --apps perf bug#4905845,sql id 16103462
2634: --reduce comments to decrease shared memory
2635: insert into bom_explosion_temp(
2636: top_bill_sequence_id,
2637: bill_sequence_id,
2638: organization_id,
2639: sort_order,

Line 2685: bom_explosion_temp be

2681: bom_inventory_components bic,
2682: eng_revised_items eri,
2683: bom_bill_of_materials bom,
2684: mtl_parameters mp,
2685: bom_explosion_temp be
2686: where be.sort_order <> 3
2687: and be.group_id = xGrpId
2688: and nvl(be.plan_level,0) = level_number
2689: and be.organization_id = bom.organization_id

Line 2856: from bom_explosion_temp bet,mtl_system_items_kfv msi

2852: bet.sort_order,
2853: bet.plan_level,
2854: bet.line_id,
2855: substrb(msi.concatenated_segments,1,50)
2856: from bom_explosion_temp bet,mtl_system_items_kfv msi
2857: where bet.group_id = xGrpId
2858: and bet.organization_id = msi.organization_id
2859: and bet.component_item_id = msi.inventory_item_id;
2860:

Line 2910: select bom_explosion_temp_s.nextval

2906:
2907: else
2908:
2909: /* End Bugfix 2047428 */
2910: select bom_explosion_temp_s.nextval
2911: into lGroupid2
2912: from dual;
2913:
2914: select bom_explosion_temp_s.nextval

Line 2914: select bom_explosion_temp_s.nextval

2910: select bom_explosion_temp_s.nextval
2911: into lGroupid2
2912: from dual;
2913:
2914: select bom_explosion_temp_s.nextval
2915: into xGrpId
2916: from dual;
2917:
2918: lStmtNumber := 600;

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

2919:
2920:
2921: i := p_ship_set.inventory_item_id.FIRST;
2922:
2923: -- use bom_explosion_temp table to store the ship set for later join
2924: while i is not null
2925: loop
2926: insert into bom_explosion_temp(
2927: top_bill_sequence_id,

Line 2926: insert into bom_explosion_temp(

2922:
2923: -- use bom_explosion_temp table to store the ship set for later join
2924: while i is not null
2925: loop
2926: insert into bom_explosion_temp(
2927: top_bill_sequence_id,
2928: bill_sequence_id,
2929: organization_id,
2930: component_item_id,

Line 2974: -- insert the top model into bom_explosion_temp

2970: end loop;
2971:
2972:
2973:
2974: -- insert the top model into bom_explosion_temp
2975: insert into bom_explosion_temp(
2976: top_bill_sequence_id,
2977: bill_sequence_id,
2978: organization_id,

Line 2975: insert into bom_explosion_temp(

2971:
2972:
2973:
2974: -- insert the top model into bom_explosion_temp
2975: insert into bom_explosion_temp(
2976: top_bill_sequence_id,
2977: bill_sequence_id,
2978: organization_id,
2979: sort_order,

Line 3027: insert into bom_explosion_temp(

3023:
3024: level_number := level_number + 1;
3025:
3026: lStmtNumber := 610;
3027: insert into bom_explosion_temp(
3028: top_bill_sequence_id,
3029: bill_sequence_id,
3030: organization_id,
3031: sort_order,

Line 3067: bom_explosion_temp bet,

3063: from
3064: bom_bill_of_materials bom,
3065: bom_inventory_components bic,
3066: mtl_system_items msi, -- bugfix 1998386
3067: bom_explosion_temp bet,
3068: bom_explosion_temp bet2 /* ship set */
3069: where bet.group_id = xGrpId
3070: and bet.plan_level = level_number -1
3071: and bic.component_item_id = msi.inventory_item_id -- bugfix 1998386

Line 3068: bom_explosion_temp bet2 /* ship set */

3064: bom_bill_of_materials bom,
3065: bom_inventory_components bic,
3066: mtl_system_items msi, -- bugfix 1998386
3067: bom_explosion_temp bet,
3068: bom_explosion_temp bet2 /* ship set */
3069: where bet.group_id = xGrpId
3070: and bet.plan_level = level_number -1
3071: and bic.component_item_id = msi.inventory_item_id -- bugfix 1998386
3072: and bet.component_item_id = bom.assembly_item_id

Line 3126: delete from bom_explosion_temp

3122: IF PG_DEBUG <> 0 THEN
3123: oe_debug_pub.add ('load_mandatory_components: ' || 'Group_id : '|| xGrpId, 2);
3124: END IF;
3125:
3126: delete from bom_explosion_temp
3127: where group_id = lGroupid2;
3128:
3129: /*
3130: ** BUG no 1288823, new query block added

Line 3136: from mtl_system_items msi , bom_explosion_temp be

3132:
3133: begin
3134: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
3135: into v_msi_fixed_lead_time, v_msi_variable_lead_time
3136: from mtl_system_items msi , bom_explosion_temp be
3137: where be.organization_id = msi.organization_id
3138: and be.component_item_id = msi.inventory_item_id
3139: and be.component_item_id = p_ship_set.inventory_item_id(p_model_index);
3140:

Line 3168: insert into bom_explosion_temp(

3164: -- Bug 1985793 Selecting greater of sysdate and calendar date
3165: -- while checking for item effectivity so that planning will get
3166: -- components effective till sysdate.
3167: --apps performance bug#4905845, sql id 16103671
3168: insert into bom_explosion_temp(
3169: top_bill_sequence_id,
3170: bill_sequence_id,
3171: organization_id,
3172: sort_order,

Line 3218: bom_explosion_temp be

3214: bom_inventory_components bic,
3215: eng_revised_items eri,
3216: bom_bill_of_materials bom,
3217: mtl_parameters mp,
3218: bom_explosion_temp be
3219: where be.sort_order <> 3
3220: and be.group_id = xGrpId
3221: and nvl(be.plan_level,0) = level_number
3222: and be.organization_id = bom.organization_id

Line 3390: select bom_explosion_temp_s.nextval

3386: END IF;
3387: return(1);
3388:
3389: else
3390: select bom_explosion_temp_s.nextval
3391: into lGroupid2
3392: from dual;
3393:
3394: select bom_explosion_temp_s.nextval

Line 3394: select bom_explosion_temp_s.nextval

3390: select bom_explosion_temp_s.nextval
3391: into lGroupid2
3392: from dual;
3393:
3394: select bom_explosion_temp_s.nextval
3395: into xGrpId
3396: from dual;
3397:
3398: lStmtNumber := 600;

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

3399:
3400:
3401: i := p_ship_set.inventory_item_id.FIRST;
3402:
3403: -- use bom_explosion_temp table to store the ship set for later join
3404: while i is not null
3405: loop
3406: insert into bom_explosion_temp(
3407: top_bill_sequence_id,

Line 3406: insert into bom_explosion_temp(

3402:
3403: -- use bom_explosion_temp table to store the ship set for later join
3404: while i is not null
3405: loop
3406: insert into bom_explosion_temp(
3407: top_bill_sequence_id,
3408: bill_sequence_id,
3409: organization_id,
3410: component_item_id,

Line 3440: -- insert the top model into bom_explosion_temp

3436: end loop;
3437:
3438:
3439:
3440: -- insert the top model into bom_explosion_temp
3441: insert into bom_explosion_temp(
3442: top_bill_sequence_id,
3443: bill_sequence_id,
3444: organization_id,

Line 3441: insert into bom_explosion_temp(

3437:
3438:
3439:
3440: -- insert the top model into bom_explosion_temp
3441: insert into bom_explosion_temp(
3442: top_bill_sequence_id,
3443: bill_sequence_id,
3444: organization_id,
3445: sort_order,

Line 3486: insert into bom_explosion_temp(

3482:
3483: level_number := level_number + 1;
3484:
3485: lStmtNumber := 610;
3486: insert into bom_explosion_temp(
3487: top_bill_sequence_id,
3488: bill_sequence_id,
3489: organization_id,
3490: sort_order,

Line 3518: bom_explosion_temp bet,

3514: from
3515: bom_bill_of_materials bom,
3516: bom_inventory_components bic,
3517: mtl_system_items msi,
3518: bom_explosion_temp bet,
3519: bom_explosion_temp bet2
3520: where bet.group_id = xGrpId
3521: and bet.plan_level = level_number -1
3522: and bic.component_item_id = msi.inventory_item_id

Line 3519: bom_explosion_temp bet2

3515: bom_bill_of_materials bom,
3516: bom_inventory_components bic,
3517: mtl_system_items msi,
3518: bom_explosion_temp bet,
3519: bom_explosion_temp bet2
3520: where bet.group_id = xGrpId
3521: and bet.plan_level = level_number -1
3522: and bic.component_item_id = msi.inventory_item_id
3523: and msi.bom_item_type in ( 1, 2 ) /* Only Sub-models and Option Classes */

Line 3548: delete from bom_explosion_temp

3544: IF PG_DEBUG <> 0 THEN
3545: oe_debug_pub.add ('load_mandatory_components_pds: ' || 'Group_id : '|| xGrpId, 2);
3546: END IF;
3547:
3548: delete from bom_explosion_temp
3549: where group_id = lGroupid2;
3550:
3551: begin
3552: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)

Line 3554: from mtl_system_items msi , bom_explosion_temp be

3550:
3551: begin
3552: select msi.fixed_lead_time , nvl(msi.variable_lead_time,0)
3553: into v_msi_fixed_lead_time, v_msi_variable_lead_time
3554: from mtl_system_items msi , bom_explosion_temp be
3555: where be.organization_id = msi.organization_id
3556: and be.component_item_id = msi.inventory_item_id
3557: and be.component_item_id = p_ship_set.inventory_item_id(p_model_index);
3558:

Line 3584: insert into bom_explosion_temp(

3580:
3581: lStmtNumber := 620;
3582: --appsperf bug#4905845, sql id 16103821
3583: --removed comments to reduce shared memory
3584: insert into bom_explosion_temp(
3585: top_bill_sequence_id,
3586: bill_sequence_id,
3587: organization_id,
3588: sort_order,

Line 3632: bom_explosion_temp be

3628: bom_inventory_components bic,
3629: eng_revised_items eri,
3630: bom_bill_of_materials bom,
3631: mtl_parameters mp,
3632: bom_explosion_temp be
3633: where be.sort_order <> 3
3634: and be.group_id = xGrpId
3635: and nvl(be.plan_level,0) = level_number
3636: and be.organization_id = bom.organization_id

Line 3772: from bom_explosion_temp be

3768: primary_uom_code uom, -- Bugfix 1998386
3769: plan_level pl,
3770: line_id, -- Bugfix 2897132
3771: wip_supply_type -- Bugfix 3254039
3772: from bom_explosion_temp be
3773: where be.group_id = lGrpId
3774: and ( be.line_id is null or top_bill_sequence_id = -1 ) -- Bugfix 2897132
3775: and be.sort_order <> 2 ;
3776: --BUG 1288823 modification to send restricted components to atp

Line 4043: from bom_explosion_temp

4039:
4040:
4041: select count(*)
4042: into chk
4043: from bom_explosion_temp
4044: where group_id = lGrpId
4045: and ( Line_id is null or top_bill_sequence_id = -1) ; /* BugFix 2897132 */
4046:
4047: IF PG_DEBUG <> 0 THEN

Line 4119: Clean up bom_explosion_temp table

4115: END IF;
4116:
4117:
4118: /*------------------------------------+
4119: Clean up bom_explosion_temp table
4120: +------------------------------------*/
4121: lStmtNumber := 750;
4122:
4123: delete from bom_explosion_temp

Line 4123: delete from bom_explosion_temp

4119: Clean up bom_explosion_temp table
4120: +------------------------------------*/
4121: lStmtNumber := 750;
4122:
4123: delete from bom_explosion_temp
4124: where group_id = lGrpId;
4125:
4126: return(1);
4127: