APPS.BOMPCCLT dependencies on BOM_LOW_LEVEL_CODES

Line 21: BOM_LOW_LEVEL_CODES

17: Required Tables :
18: BOM_PARAMETERS
19: BOM_INVENTORY_COMPONENTS
20: BOM_BILL_OF_MATERIALS
21: BOM_LOW_LEVEL_CODES
22: MTL_SYSTEM_ITEMS
23: History
24: 20-Feb-1996 Manu Chadha
25: -Added the MTL.ORGANIZATION_ID = org_id; line to to

Line 147: Update bom_low_level_codes

143: Elsif l_err_msg is not null then
144: Raise l_FatalError;
145: Else
146: l_stmt := '4';
147: Update bom_low_level_codes
148: Set low_level_code = p_level,
149: program_update_date = sysdate
150: Where rollup_id = p_roll_id
151: And inventory_item_id = l_comps_rec.component_item_id

Line 154: Insert into bom_low_level_codes(

150: Where rollup_id = p_roll_id
151: And inventory_item_id = l_comps_rec.component_item_id
152: And low_level_code < p_level;
153: l_stmt := '5';
154: Insert into bom_low_level_codes(
155: rollup_id,
156: inventory_item_id,
157: low_level_code,
158: request_id,

Line 173: From bom_low_level_codes

169: sysdate
170: From dual
171: Where not exists(
172: Select null
173: From bom_low_level_codes
174: Where rollup_id = p_roll_id
175: And inventory_item_id = l_comps_rec.component_item_id
176: And low_level_code >= p_level);
177: End if;

Line 243: -- explode the assemblies in list and insert into BOM_LOW_LEVEL_CODES

239: If max_bom_level is NULL then
240: max_bom_level := l_AbsoluteMaxLevel;
241: End if;
242:
243: -- explode the assemblies in list and insert into BOM_LOW_LEVEL_CODES
244:
245: --bom_debug('starting walk down of ' || alternate_bom_code);
246:
247: l_LoopFound := false;

Line 275: Insert into bom_low_level_codes(

271: Elsif l_err_msg is not null then
272: Raise l_FatalError;
273: Else
274: l_stmt_num := '3';
275: Insert into bom_low_level_codes(
276: rollup_id,
277: inventory_item_id,
278: low_level_code,
279: request_id,

Line 294: From bom_low_level_codes

290: sysdate
291: From dual
292: Where not exists(
293: Select null
294: From bom_low_level_codes
295: Where rollup_id = roll_id
296: And inventory_item_id = l_bill_rec.assembly_item_id
297: And low_level_code >= 0);
298: End if;

Line 334: From bom_low_level_codes

330: X_include_models varchar2(1) := 'N';
331:
332: cursor l_LowLevelCode_csr is
333: Select nvl(max(low_level_code), -1) depth
334: From bom_low_level_codes
335: Where rollup_id = roll_id;
336: l_depth number;
337:
338: CURSOR l_assy_csr(p_level number) is

Line 350: bom_low_level_codes LLC

346: NVL(MTL.FULL_LEAD_TIME, 0)) FULL_LEAD_TIME,
347: MTL.PLANNING_MAKE_BUY_CODE,
348: MTL.bom_item_type bom_item_type
349: from mtl_system_items MTL,
350: bom_low_level_codes LLC
351: where LLC.ROLLUP_ID = roll_id
352: AND LLC.LOW_LEVEL_CODE = p_level
353: AND MTL.INVENTORY_ITEM_ID = LLC.INVENTORY_ITEM_ID
354: AND MTL.ORGANIZATION_ID = org_id

Line 510: DELETE FROM BOM_LOW_LEVEL_CODES

506: BEGIN
507: l_RowsFound := true;
508: While l_RowsFound
509: LOOP
510: DELETE FROM BOM_LOW_LEVEL_CODES
511: WHERE ROLLUP_ID = p_rollup_id
512: and rownum <= G_CommitRows;
513: l_RowsFound := sql%found;
514: End loop;

Line 538: DELETE FROM BOM_LOW_LEVEL_CODES

534: BEGIN
535: l_RowsFound := true;
536: While l_RowsFound loop
537: l_stmt := '1';
538: DELETE FROM BOM_LOW_LEVEL_CODES
539: WHERE ROLLUP_ID = roll_id
540: and rownum <= G_CommitRows;
541: l_RowsFound := sql%found;
542: End loop;

Line 573: DELETE FROM BOM_LOW_LEVEL_CODES

569:
570: l_RowsFound := true;
571: While l_RowsFound loop
572: l_stmt := '2';
573: DELETE FROM BOM_LOW_LEVEL_CODES
574: WHERE ROLLUP_ID = roll_id
575: and rownum <= G_CommitRows;
576: l_RowsFound := sql%found;
577: End loop;