APPS.BOMPXINQ dependencies on BOM_BILL_OF_MATERIALS

Line 269: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM

265:
266: SELECT
267: substrb(MIF.ITEM_NUMBER || ' ' || BBM.ALTERNATE_BOM_DESIGNATOR,1,16)
268: INTO cur_msgstr
269: FROM MTL_ITEM_FLEXFIELDS MIF, BOM_BILL_OF_MATERIALS BBM
270: WHERE MIF.ORGANIZATION_ID = BBM.ORGANIZATION_ID
271: AND MIF.ITEM_ID = BBM.ASSEMBLY_ITEM_ID
272: AND BBM.ASSEMBLY_ITEM_ID = cur_item_id
273: AND BBM.ORGANIZATION_ID = org_id

Line 279: ( EXISTS ( SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM1

275: ((top_alt = 'none') AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL)
276: OR
277: ((top_alt <> 'none')
278: AND (
279: ( EXISTS ( SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM1
280: WHERE BBM1.ORGANIZATION_ID = org_id
281: AND BBM1.ASSEMBLY_ITEM_ID = cur_item_id
282: AND BBM1.ALTERNATE_BOM_DESIGNATOR = top_alt)
283: AND BBM.ALTERNATE_BOM_DESIGNATOR = top_alt

Line 286: ( NOT EXISTS (SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM2

282: AND BBM1.ALTERNATE_BOM_DESIGNATOR = top_alt)
283: AND BBM.ALTERNATE_BOM_DESIGNATOR = top_alt
284: )
285: OR
286: ( NOT EXISTS (SELECT NULL FROM BOM_BILL_OF_MATERIALS BBM2
287: WHERE BBM2.ORGANIZATION_ID = org_id
288: AND BBM2.ASSEMBLY_ITEM_ID = cur_item_id
289: AND BBM2.ALTERNATE_BOM_DESIGNATOR = top_alt)
290: AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL

Line 378: from BOM_SMALL_EXPL_TEMP BET, bom_bill_of_materials bbm, mtl_system_items msi1, mtl_system_items msi2

374: BET.common_bill_sequence_id curCBSI,
375: msi1.organization_id t_master_org_id,
376: msi1.primary_uom_code t_master_uom,
377: msi2.primary_uom_code t_child_uom
378: from BOM_SMALL_EXPL_TEMP BET, bom_bill_of_materials bbm, mtl_system_items msi1, mtl_system_items msi2
379: where BET.bill_sequence_id <> BET.common_bill_sequence_id
380: and bbm.bill_sequence_id = BET.common_bill_sequence_id
381: and msi1.inventory_item_id = BET.component_item_id
382: and msi1.organization_id = bbm.organization_id

Line 454: from bom_bill_of_materials bom, mtl_system_items msi

450: 2,
451: alt_desg,
452: msi.bom_item_type,
453: msi.bom_item_type
454: from bom_bill_of_materials bom, mtl_system_items msi
455: where bom.assembly_item_id = item_id
456: and bom.organization_id = org_id
457: and nvl(alternate_bom_designator, 'NONE') =
458: nvl(alt_desg, 'NONE')

Line 545: from mtl_system_items msi, bom_bill_of_materials bbm

541:
542: /* Bug 9355186 - This information in queried in cursor cur
543: select msi.primary_uom_code, msi.organization_id into
544: t_master_uom, t_master_org_id
545: from mtl_system_items msi, bom_bill_of_materials bbm
546: where cr.curCBSI = bbm.bill_sequence_id and
547: bbm.organization_id = msi.organization_id and
548: msi.inventory_item_id = cr.curCII;
549:

Line 837: FROM bom_bill_of_materials

833: BEGIN
834: --dbms_output.put_line('organization: ' || t_org_code_list(I));
835:
836: SELECT assembly_item_id INTO c_assembly_item_id
837: FROM bom_bill_of_materials
838: WHERE assembly_item_id = l_assembly_item_id
839: AND organization_id = t_org_code_list(I)
840: AND nvl(ALTERNATE_BOM_DESIGNATOR,'NONE')=
841: nvl(Alternate_bm_designator,'NONE') ;

Line 1154: FROM bom_bill_of_materials

1150: attribute12,
1151: attribute13,
1152: attribute14,
1153: attribute15
1154: FROM bom_bill_of_materials
1155: WHERE bill_sequence_id = p_bill_sequence_id;
1156: --AND NVL(alternate_bom_designator, '##$$##') = NVL(P_alternate_bm_designator, '##$$##');
1157:
1158: CURSOR Revision_Details_CUR IS