APPS.ENG_BOM_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 130: UPDATE BOM_BILL_OF_MATERIALS

126: X_stmt_num := 400;
127:
128: X_GTIN_ST_TYPE_ID := Get_GTIN_Structure_Type_Id;
129:
130: UPDATE BOM_BILL_OF_MATERIALS
131: SET ASSEMBLY_TYPE = 1,
132: LAST_UPDATE_DATE = sysdate,
133: LAST_UPDATED_BY = to_number(fnd_profile.value('USER_ID'))
134: WHERE ORGANIZATION_ID = X_org_id

Line 179: FROM BOM_BILL_OF_MATERIALS BOM_T

175: < X_unit_number)))
176: OR (X_transfer_option = 3 AND
177: NVL(BIC.TO_END_ITEM_UNIT_NUMBER, X_unit_number) < X_unit_number))
178: AND BIC.BILL_SEQUENCE_ID in (SELECT BOM_T.BILL_SEQUENCE_ID
179: FROM BOM_BILL_OF_MATERIALS BOM_T
180: WHERE ORGANIZATION_ID = X_org_id
181: AND ASSEMBLY_ITEM_ID = X_eng_item_id
182: AND ASSEMBLY_TYPE = 1
183: AND ((X_designator_option = 2 AND ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 199: FROM BOM_BILL_OF_MATERIALS BOM_T

195: <= X_effectivity_date))
196: OR (X_transfer_option = 3 AND NVL(BIC.DISABLE_DATE, X_effectivity_date +
197: 1) <= X_effectivity_date))
198: AND BIC.BILL_SEQUENCE_ID in (SELECT BOM_T.BILL_SEQUENCE_ID
199: FROM BOM_BILL_OF_MATERIALS BOM_T
200: WHERE ORGANIZATION_ID = X_org_id
201: AND ASSEMBLY_ITEM_ID = X_eng_item_id
202: AND ASSEMBLY_TYPE = 1
203: AND ((X_designator_option = 2 AND ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 315: FROM BOM_BILL_OF_MATERIALS

311: --BOM ER 9946990 end
312:
313: CURSOR BOM_CURSOR IS
314: SELECT BILL_SEQUENCE_ID, ALTERNATE_BOM_DESIGNATOR
315: FROM BOM_BILL_OF_MATERIALS
316: WHERE ORGANIZATION_ID = X_org_id
317: AND ASSEMBLY_ITEM_ID = X_mfg_item_id
318: AND nvl(effectivity_control, 1) <> 4 -- Bug 4210718
319: AND Source_BILL_SEQUENCE_ID = BILL_SEQUENCE_ID; --R12

Line 324: FROM BOM_BILL_OF_MATERIALS BOM_T

320:
321: -- BUG 3503220
322: CURSOR BOM_COPIES IS
323: SELECT BILL_SEQUENCE_ID, ALTERNATE_BOM_DESIGNATOR, assembly_item_id, organization_id, obj_name
324: FROM BOM_BILL_OF_MATERIALS BOM_T
325: WHERE ORGANIZATION_ID = X_org_id
326: AND ASSEMBLY_ITEM_ID = X_mfg_item_id
327: AND nvl(BOM_T.effectivity_control, 1) <> 4 -- Bug 4210718
328: AND ((X_designator_option = 2 AND

Line 397: --- BOM_BILL_OF_MATERIALS

393:
394:
395: --BOM ER 9946990 end
396:
397: --- BOM_BILL_OF_MATERIALS
398:
399: X_stmt_num := 700;
400:
401:

Line 413: INSERT INTO BOM_BILL_OF_MATERIALS(

409: ELSE
410: FLAG:= 0;
411: END IF;
412: -- Bug 3523263 Bug 4240131 inserted effectivity_control in table.
413: INSERT INTO BOM_BILL_OF_MATERIALS(
414: ASSEMBLY_ITEM_ID,
415: ORGANIZATION_ID,
416: ALTERNATE_BOM_DESIGNATOR,
417: LAST_UPDATE_DATE,

Line 497: FROM BOM_BILL_OF_MATERIALS BOM_T

493: DECODE(BOM_T.COMMON_BILL_SEQUENCE_ID,BOM_T.BILL_SEQUENCE_ID,BOM_INVENTORY_COMPONENTS_S.CURRVAL,BOM_T.COMMON_BILL_SEQUENCE_ID),
494: STRUCTURE_TYPE_ID, -- Bug 12555524
495: X_mfg_item_id,
496: ORGANIZATION_ID
497: FROM BOM_BILL_OF_MATERIALS BOM_T
498: WHERE ORGANIZATION_ID = X_org_id
499: AND ASSEMBLY_ITEM_ID = X_eng_item_id
500: AND ((X_designator_option = 2 AND
501: BOM_T.ALTERNATE_BOM_DESIGNATOR IS NULL)

Line 549: FROM BOM_BILL_OF_MATERIALS

545: X_stmt_num := 701;
546: BEGIN
547: SELECT BILL_SEQUENCE_ID
548: INTO X_from_bill_sequence_id
549: FROM BOM_BILL_OF_MATERIALS
550: WHERE ORGANIZATION_ID = X_org_id
551: AND ASSEMBLY_ITEM_ID = X_eng_item_id
552: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(BOM1.ALTERNATE_BOM_DESIGNATOR,'NONE');
553: EXCEPTION

Line 585: UPDATE BOM_BILL_OF_MATERIALS BOM1

581: from_item_id =>X_eng_item_id);
582:
583: END LOOP;
584: IF FLAG=1 THEN -- 3503263
585: UPDATE BOM_BILL_OF_MATERIALS BOM1
586: SET BOM1.ALTERNATE_BOM_DESIGNATOR =NULL
587: WHERE ORGANIZATION_ID = X_org_id
588: AND ASSEMBLY_ITEM_ID = X_mfg_item_id
589: AND (X_designator_option = 3 AND