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

Line 3916: bom_explosion_temp bet

3912: mtl_system_items si2,
3913: bom_bill_of_materials bbm,
3914: bom_inventory_components bic, -- Components
3915: bom_inventory_components bic1, -- Parent
3916: bom_explosion_temp bet
3917: /*-----------------------------------------------------------------------------------------------------+
3918: For a multilevel model , ato_line_id=xLineId will not fetch included items of lower level
3919: non-phantom models so Parent_ATO_Line_id is used in the join condition.
3920: e.g. For a bill like this :

Line 3981: SELECT /+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) /

3977: and ( bic.disable_date is null or
3978: (bic.disable_date is not null and bic.disable_date >= sysdate )) ;/* New Approach for Effectivity Dates */
3979:
3980: CURSOR c_model_oc_oi_rows(xConfigBillId bom_inventory_components.bill_sequence_id%TYPE) IS
3981: SELECT /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
3982: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
3983: component_code,
3984: rowid
3985: from bom_explosion_temp

Line 3985: from bom_explosion_temp

3981: SELECT /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
3982: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
3983: component_code,
3984: rowid
3985: from bom_explosion_temp
3986: where bill_sequence_id = xConfigBillId
3987: and component_code IS NOT NULL
3988: ORDER BY component_code;
3989:

Line 4032: INSERT INTO BOM_EXPLOSION_TEMP

4028: -- component_code to insert comp_code of classes /items
4029: -- from bcol
4030: --
4031:
4032: INSERT INTO BOM_EXPLOSION_TEMP
4033: ( top_bill_sequence_id,
4034: organization_id,
4035: plan_level,
4036: sort_order,

Line 4213: select /+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) /

4209:
4210:
4211:
4212:
4213: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4214: count(*) into v_zero_qty_count from bom_explosion_temp
4215: where bill_sequence_id = pConfigBillId and component_quantity = 0 ;
4216:
4217: oe_debug_pub.add( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;

Line 4214: count(*) into v_zero_qty_count from bom_explosion_temp

4210:
4211:
4212:
4213: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4214: count(*) into v_zero_qty_count from bom_explosion_temp
4215: where bill_sequence_id = pConfigBillId and component_quantity = 0 ;
4216:
4217: oe_debug_pub.add( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
4218:

Line 4253: update bom_explosion_temp set disable_date = g_futuredate

4249:
4250: /* begin Extend Effectivity Dates for Option Items with disable date */
4251:
4252:
4253: update bom_explosion_temp set disable_date = g_futuredate
4254: where ( component_item_id , operation_seq_num, nvl(assembly_item_id,-1) , disable_date) in
4255: ( select component_item_id, operation_seq_num, nvl(assembly_item_id,-1), max(disable_date)
4256: from bom_inventory_comps_interface
4257: where bill_sequence_id = pConfigBillId

Line 4277: INSERT INTO bom_explosion_temp

4273: lStmtNumber := 510;
4274:
4275: /*Insert Incl. items under Base Model */
4276:
4277: INSERT INTO bom_explosion_temp
4278: (
4279: top_bill_sequence_id,
4280: organization_id,
4281: plan_level,

Line 4452: UPDATE bom_explosion_temp bet

4448: +------------------------------------------------------------------------------------------------------------+*/
4449:
4450: FOR r1 in c_model_oc_oi_rows(pConfigBillId) LOOP
4451: IF r1.operation_seq_num = 1 AND instr(r1.component_code,'-',1,2)<>0 THEN
4452: UPDATE bom_explosion_temp bet
4453: SET bet.operation_seq_num = (
4454: SELECT /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4455: nvl(operation_seq_num,1) -- 2433862
4456: FROM bom_explosion_temp

Line 4454: SELECT /+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) /

4450: FOR r1 in c_model_oc_oi_rows(pConfigBillId) LOOP
4451: IF r1.operation_seq_num = 1 AND instr(r1.component_code,'-',1,2)<>0 THEN
4452: UPDATE bom_explosion_temp bet
4453: SET bet.operation_seq_num = (
4454: SELECT /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4455: nvl(operation_seq_num,1) -- 2433862
4456: FROM bom_explosion_temp
4457: WHERE component_code = substr(bet.component_code,1,to_number(instr(bet.component_code,'-',-1,1))-1)
4458: AND bill_sequence_id = pConfigBillId

Line 4456: FROM bom_explosion_temp

4452: UPDATE bom_explosion_temp bet
4453: SET bet.operation_seq_num = (
4454: SELECT /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4455: nvl(operation_seq_num,1) -- 2433862
4456: FROM bom_explosion_temp
4457: WHERE component_code = substr(bet.component_code,1,to_number(instr(bet.component_code,'-',-1,1))-1)
4458: AND bill_sequence_id = pConfigBillId
4459: AND top_bill_sequence_id = pConfigBillId)
4460: WHERE component_code = r1.component_code

Line 4470: INSERT INTO bom_explosion_temp

4466:
4467: /* Open cursor c_incl_items_all_level */
4468:
4469: FOR r2 in c_incl_items_all_level (pOrgId ,pLineId ,pConfigBillId,g_SchShpDate,g_EstRelDate ) LOOP
4470: INSERT INTO bom_explosion_temp
4471: ( top_bill_sequence_id,
4472: organization_id,
4473: plan_level,
4474: sort_order,

Line 4652: select /+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) /

4648: assembly_item_id /* Bug Fix: 4147224 */
4649: , basis_type, /* LBM changes */
4650: batch_id
4651: )
4652: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4653: nvl(operation_seq_num,1), -- 2433862
4654: component_item_id,
4655: SYSDATE, -- last_updated_date
4656: 1, -- last_updated_by

Line 4722: from bom_explosion_temp

4718: top_item_id,
4719: assembly_item_id /* Bug Fix: 4147224 */
4720: , nvl(basis_type,1), /* LBM project */
4721: cto_msutil_pub.bom_batch_id
4722: from bom_explosion_temp
4723: where bill_sequence_id = pConfigBillId;
4724:
4725: lCnt := sql%rowcount ;
4726: IF PG_DEBUG <> 0 THEN

Line 4838: DELETE /+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) /

4834:
4835: lStmtNumber := 560;
4836:
4837: /*Flushing the temp table*/
4838: DELETE /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4839: from bom_explosion_temp
4840: WHERE bill_sequence_id = pConfigBillId;
4841:
4842: return(1);

Line 4839: from bom_explosion_temp

4835: lStmtNumber := 560;
4836:
4837: /*Flushing the temp table*/
4838: DELETE /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
4839: from bom_explosion_temp
4840: WHERE bill_sequence_id = pConfigBillId;
4841:
4842: return(1);
4843: