DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_EXPLOSION_TEMP

Line 5930: bom_explosion_temp bet

5926: mtl_system_items si2,
5927: bom_bill_of_materials bbm,
5928: bom_inventory_components bic, -- Components
5929: bom_inventory_components bic1, -- Parent
5930: bom_explosion_temp bet
5931: where bcol1.parent_ato_line_id = xLineId
5932: and bcol1.component_code = bet.component_code
5933: and si1.organization_id = xOrgId
5934: and bcol1.inventory_item_id = si1.inventory_item_id

Line 5962: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */

5958: and NVL(bic.disable_date,NVL(xEstReldt, SYSDATE)+1) > NVL(xEstReldt,SYSDATE)
5959: and NVL(bic.disable_date,SYSDATE) >= SYSDATE;
5960:
5961: CURSOR c_model_oc_oi_rows(xConfigBillId bom_inventory_components.bill_sequence_id%TYPE) IS
5962: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
5963: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
5964: component_code,
5965: rowid
5966: from bom_explosion_temp

Line 5966: from bom_explosion_temp

5962: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
5963: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
5964: component_code,
5965: rowid
5966: from bom_explosion_temp
5967: where bill_sequence_id = xConfigBillId
5968: and component_code IS NOT NULL
5969: ORDER BY component_code;
5970:

Line 6010: insert into bom_explosion_temp

6006: -- component_code to insert comp_code of classes /items
6007: -- from bcol
6008: --
6009:
6010: insert into bom_explosion_temp
6011: ( top_bill_sequence_id,
6012: organization_id,
6013: plan_level,
6014: sort_order,

Line 6184: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */

6180:
6181:
6182: /* 04-04-2005 begin zero qty check */
6183:
6184: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6185: count(*) into v_zero_qty_count from bom_explosion_temp
6186: where bill_sequence_id = pConfigBillId and component_quantity = 0 ;
6187:
6188: WriteToLog( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;

Line 6185: count(*) into v_zero_qty_count from bom_explosion_temp

6181:
6182: /* 04-04-2005 begin zero qty check */
6183:
6184: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6185: count(*) into v_zero_qty_count from bom_explosion_temp
6186: where bill_sequence_id = pConfigBillId and component_quantity = 0 ;
6187:
6188: WriteToLog( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
6189:

Line 6225: INSERT INTO bom_explosion_temp

6221: lStmtNumber := 510;
6222:
6223: /*Insert Incl. items under Base Model */
6224:
6225: INSERT INTO bom_explosion_temp
6226: (
6227: top_bill_sequence_id,
6228: organization_id,
6229: plan_level,

Line 6394: UPDATE bom_explosion_temp bet

6390: IF r1.operation_seq_num = 1 AND instr(r1.component_code,'-',1,2)<>0 THEN
6391: IF PG_DEBUG <> 0 THEN -- 13079222
6392: oe_debug_pub.add ('Component Code: ' || r1.component_code,1);
6393: END IF;
6394: UPDATE bom_explosion_temp bet
6395: SET bet.operation_seq_num = (
6396: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6397: nvl(operation_seq_num,1) -- 2433862
6398: FROM bom_explosion_temp

Line 6396: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */

6392: oe_debug_pub.add ('Component Code: ' || r1.component_code,1);
6393: END IF;
6394: UPDATE bom_explosion_temp bet
6395: SET bet.operation_seq_num = (
6396: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6397: nvl(operation_seq_num,1) -- 2433862
6398: FROM bom_explosion_temp
6399: WHERE component_code = substr(bet.component_code,1,to_number(instr(bet.component_code,'-',-1,1))-1)
6400: AND bill_sequence_id = pConfigBillId

Line 6398: FROM bom_explosion_temp

6394: UPDATE bom_explosion_temp bet
6395: SET bet.operation_seq_num = (
6396: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6397: nvl(operation_seq_num,1) -- 2433862
6398: FROM bom_explosion_temp
6399: WHERE component_code = substr(bet.component_code,1,to_number(instr(bet.component_code,'-',-1,1))-1)
6400: AND bill_sequence_id = pConfigBillId
6401: AND top_bill_sequence_id = pConfigBillId)
6402: WHERE component_code = r1.component_code

Line 6412: INSERT INTO bom_explosion_temp

6408:
6409: /* Open cursor c_incl_items_all_level */
6410:
6411: FOR r2 in c_incl_items_all_level (pOrgId ,pLineId ,pConfigBillId,g_SchShpDate,g_EstRelDate ) LOOP
6412: INSERT INTO bom_explosion_temp
6413: ( top_bill_sequence_id,
6414: organization_id,
6415: plan_level,
6416: sort_order,

Line 6592: select /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */

6588: assembly_item_id /* Bug Fix 4147224 */
6589: , basis_type, /* LBM changes */
6590: batch_id
6591: )
6592: select /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6593: nvl(operation_seq_num,1), -- 2433862
6594: component_item_id,
6595: SYSDATE, -- last_updated_date
6596: 1, -- last_updated_by

Line 6661: from bom_explosion_temp

6657: top_item_id,
6658: assembly_item_id /* Bug Fix: 4147224 */
6659: , nvl(basis_type,1), /* LBM project */
6660: cto_msutil_pub.bom_batch_id
6661: from bom_explosion_temp
6662: where bill_sequence_id = pConfigBillId;
6663:
6664: lCnt := sql%rowcount ;
6665: WriteToLog('Inherit_op_seq_ml:Inserted in BIC Interface ' || lCnt ||' rows from BET', 4);

Line 6778: DELETE /*+ INDEX (BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11 ) */

6774:
6775: lStmtNumber := 560;
6776:
6777: /*Flushing the temp table*/
6778: DELETE /*+ INDEX (BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11 ) */
6779: from bom_explosion_temp
6780: WHERE bill_sequence_id = pConfigBillId;
6781:
6782: return(1);

Line 6779: from bom_explosion_temp

6775: lStmtNumber := 560;
6776:
6777: /*Flushing the temp table*/
6778: DELETE /*+ INDEX (BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11 ) */
6779: from bom_explosion_temp
6780: WHERE bill_sequence_id = pConfigBillId;
6781:
6782: return(1);
6783: