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 440: from bom_bill_of_materials bom, mtl_system_items msi

436: 2,
437: alt_desg,
438: msi.bom_item_type,
439: msi.bom_item_type
440: from bom_bill_of_materials bom, mtl_system_items msi
441: where bom.assembly_item_id = item_id
442: and bom.organization_id = org_id
443: and nvl(alternate_bom_designator, 'NONE') =
444: nvl(alt_desg, 'NONE')

Line 525: from mtl_system_items msi, bom_bill_of_materials bbm

521:
522: FOR cr IN cur LOOP
523: select msi.primary_uom_code, msi.organization_id into
524: t_master_uom, t_master_org_id
525: from mtl_system_items msi, bom_bill_of_materials bbm
526: where cr.curCBSI = bbm.bill_sequence_id and
527: bbm.organization_id = msi.organization_id and
528: msi.inventory_item_id = cr.curCII;
529:

Line 793: FROM bom_bill_of_materials

789: BEGIN
790: --dbms_output.put_line('organization: ' || t_org_code_list(I));
791:
792: SELECT assembly_item_id INTO c_assembly_item_id
793: FROM bom_bill_of_materials
794: WHERE assembly_item_id = l_assembly_item_id
795: AND organization_id = t_org_code_list(I)
796: AND nvl(ALTERNATE_BOM_DESIGNATOR,'NONE')=
797: nvl(Alternate_bm_designator,'NONE') ;

Line 1110: FROM bom_bill_of_materials

1106: attribute12,
1107: attribute13,
1108: attribute14,
1109: attribute15
1110: FROM bom_bill_of_materials
1111: WHERE bill_sequence_id = p_bill_sequence_id;
1112: --AND NVL(alternate_bom_designator, '##$$##') = NVL(P_alternate_bm_designator, '##$$##');
1113:
1114: CURSOR Revision_Details_CUR IS