DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_EXPLOSION_TEMP

Line 5721: bom_explosion_temp bet

5717: mtl_system_items si2,
5718: bom_bill_of_materials bbm,
5719: bom_inventory_components bic, -- Components
5720: bom_inventory_components bic1, -- Parent
5721: bom_explosion_temp bet
5722: where bcol1.parent_ato_line_id = xLineId
5723: and bcol1.component_code = bet.component_code
5724: and si1.organization_id = xOrgId
5725: and bcol1.inventory_item_id = si1.inventory_item_id

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

5749: and NVL(bic.disable_date,NVL(xEstReldt, SYSDATE)+1) > NVL(xEstReldt,SYSDATE)
5750: and NVL(bic.disable_date,SYSDATE) >= SYSDATE;
5751:
5752: CURSOR c_model_oc_oi_rows(xConfigBillId bom_inventory_components.bill_sequence_id%TYPE) IS
5753: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
5754: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
5755: component_code,
5756: rowid
5757: from bom_explosion_temp

Line 5757: from bom_explosion_temp

5753: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
5754: nvl(operation_seq_num,1) operation_seq_num, -- 2433862
5755: component_code,
5756: rowid
5757: from bom_explosion_temp
5758: where bill_sequence_id = xConfigBillId
5759: and component_code IS NOT NULL
5760: ORDER BY component_code;
5761:

Line 5801: insert into bom_explosion_temp

5797: -- component_code to insert comp_code of classes /items
5798: -- from bcol
5799: --
5800:
5801: insert into bom_explosion_temp
5802: ( top_bill_sequence_id,
5803: organization_id,
5804: plan_level,
5805: sort_order,

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

5971:
5972:
5973: /* 04-04-2005 begin zero qty check */
5974:
5975: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
5976: count(*) into v_zero_qty_count from bom_explosion_temp
5977: where bill_sequence_id = pConfigBillId and component_quantity = 0 ;
5978:
5979: WriteToLog( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;

Line 5976: count(*) into v_zero_qty_count from bom_explosion_temp

5972:
5973: /* 04-04-2005 begin zero qty check */
5974:
5975: select /*+ INDEX ( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
5976: count(*) into v_zero_qty_count from bom_explosion_temp
5977: where bill_sequence_id = pConfigBillId and component_quantity = 0 ;
5978:
5979: WriteToLog( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
5980:

Line 6016: INSERT INTO bom_explosion_temp

6012: lStmtNumber := 510;
6013:
6014: /*Insert Incl. items under Base Model */
6015:
6016: INSERT INTO bom_explosion_temp
6017: (
6018: top_bill_sequence_id,
6019: organization_id,
6020: plan_level,

Line 6182: UPDATE bom_explosion_temp bet

6178: +------------------------------------------------------------------------------------------------------------+*/
6179:
6180: FOR r1 in c_model_oc_oi_rows(pConfigBillId) LOOP
6181: IF r1.operation_seq_num = 1 AND instr(r1.component_code,'-',1,2)<>0 THEN
6182: UPDATE bom_explosion_temp bet
6183: SET bet.operation_seq_num = (
6184: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6185: nvl(operation_seq_num,1) -- 2433862
6186: FROM bom_explosion_temp

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

6180: FOR r1 in c_model_oc_oi_rows(pConfigBillId) LOOP
6181: IF r1.operation_seq_num = 1 AND instr(r1.component_code,'-',1,2)<>0 THEN
6182: UPDATE bom_explosion_temp bet
6183: SET bet.operation_seq_num = (
6184: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6185: nvl(operation_seq_num,1) -- 2433862
6186: FROM bom_explosion_temp
6187: WHERE component_code = substr(bet.component_code,1,to_number(instr(bet.component_code,'-',-1,1))-1)
6188: AND bill_sequence_id = pConfigBillId

Line 6186: FROM bom_explosion_temp

6182: UPDATE bom_explosion_temp bet
6183: SET bet.operation_seq_num = (
6184: SELECT /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6185: nvl(operation_seq_num,1) -- 2433862
6186: FROM bom_explosion_temp
6187: WHERE component_code = substr(bet.component_code,1,to_number(instr(bet.component_code,'-',-1,1))-1)
6188: AND bill_sequence_id = pConfigBillId
6189: AND top_bill_sequence_id = pConfigBillId)
6190: WHERE component_code = r1.component_code

Line 6200: INSERT INTO bom_explosion_temp

6196:
6197: /* Open cursor c_incl_items_all_level */
6198:
6199: FOR r2 in c_incl_items_all_level (pOrgId ,pLineId ,pConfigBillId,g_SchShpDate,g_EstRelDate ) LOOP
6200: INSERT INTO bom_explosion_temp
6201: ( top_bill_sequence_id,
6202: organization_id,
6203: plan_level,
6204: sort_order,

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

6376: assembly_item_id /* Bug Fix 4147224 */
6377: , basis_type, /* LBM changes */
6378: batch_id
6379: )
6380: select /*+ INDEX( BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11) */
6381: nvl(operation_seq_num,1), -- 2433862
6382: component_item_id,
6383: SYSDATE, -- last_updated_date
6384: 1, -- last_updated_by

Line 6449: from bom_explosion_temp

6445: top_item_id,
6446: assembly_item_id /* Bug Fix: 4147224 */
6447: , nvl(basis_type,1), /* LBM project */
6448: cto_msutil_pub.bom_batch_id
6449: from bom_explosion_temp
6450: where bill_sequence_id = pConfigBillId;
6451:
6452: lCnt := sql%rowcount ;
6453: WriteToLog('Inherit_op_seq_ml:Inserted in BIC Interface ' || lCnt ||' rows from BET', 4);

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

6562:
6563: lStmtNumber := 560;
6564:
6565: /*Flushing the temp table*/
6566: DELETE /*+ INDEX (BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11 ) */
6567: from bom_explosion_temp
6568: WHERE bill_sequence_id = pConfigBillId;
6569:
6570: return(1);

Line 6567: from bom_explosion_temp

6563: lStmtNumber := 560;
6564:
6565: /*Flushing the temp table*/
6566: DELETE /*+ INDEX (BOM_EXPLOSION_TEMP BOM_EXPLOSION_TEMP_N11 ) */
6567: from bom_explosion_temp
6568: WHERE bill_sequence_id = pConfigBillId;
6569:
6570: return(1);
6571: