APPS.BOM_COMPONENT_API dependencies on BOM_BILL_OF_MATERIALS

Line 274: FROM bom_bill_of_materials bom,

270: BEGIN
271: SELECT bom.bill_sequence_id, msi.bom_item_type,
272: msi.atp_components_flag
273: INTO c1rec.BSI, x_bom_item_type, x_atp_comp_flag
274: FROM bom_bill_of_materials bom,
275: mtl_system_items msi
276: WHERE bom.organization_id = c1rec.OI
277: AND bom.assembly_item_id = c1rec.AII
278: AND nvl(bom.alternate_bom_designator, 'NONE') =

Line 316: FROM bom_bill_of_materials bom,

312: bom.alternate_bom_designator, msi.bom_item_type,
313: msi.atp_components_flag
314: INTO c1rec.AII, c1rec.OI, c1rec.ABD, x_bom_item_type,
315: x_atp_comp_flag
316: FROM bom_bill_of_materials bom,
317: mtl_system_items msi
318: WHERE bom.bill_sequence_id = c1rec.BSI
319: AND msi.organization_id = bom.organization_id
320: AND msi.inventory_item_id = bom.assembly_item_id;

Line 765: FROM bom_bill_of_materials bom,

761: BEGIN
762: SELECT bom.bill_sequence_id, bom.assembly_type,
763: msi.bom_item_type
764: INTO c2rec.BSI, c2rec.AST, x_bom_item_type
765: FROM bom_bill_of_materials bom,
766: mtl_system_items msi
767: WHERE bom.organization_id = c2rec.OI
768: AND bom.assembly_item_id = c2rec.AII
769: AND nvl(bom.alternate_bom_designator, 'NONE') =

Line 807: FROM bom_bill_of_materials bom,

803: bom.alternate_bom_designator, bom.assembly_type,
804: msi.bom_item_type
805: INTO c2rec.AII, c2rec.OI, c2rec.ABD, c2rec.AST,
806: x_bom_item_type
807: FROM bom_bill_of_materials bom,
808: mtl_system_items msi
809: WHERE bom.bill_sequence_id = c2rec.BSI
810: AND msi.organization_id = bom.organization_id
811: AND msi.inventory_item_id = bom.assembly_item_id;

Line 918: bom_bill_of_materials bbom,

914: bic.component_item_id, msi.bom_item_type
915: INTO c2rec.AII, c2rec.OI, c2rec.BSI, c2rec.ABD, c2rec.AST,
916: c2rec.CII, x_bom_item_type
917: FROM mtl_system_items msi,
918: bom_bill_of_materials bbom,
919: bom_inventory_components bic
920: WHERE bbom.bill_sequence_id = bic.bill_sequence_id
921: AND bic.component_sequence_id = c2rec.CSI
922: AND msi.organization_id = bbom.organization_id

Line 3542: bom_bill_of_materials bom

3538: DECLARE
3539: CURSOR GetBOMItemType IS
3540: SELECT bom_item_type, assembly_item_id
3541: FROM mtl_system_items msi,
3542: bom_bill_of_materials bom
3543: WHERE msi.organization_id = bom.organization_id
3544: AND msi.inventory_item_id = bom.assembly_item_id
3545: AND bom.bill_sequence_id = c1rec.BSI;
3546: BEGIN

Line 3661: FROM bom_bill_of_materials

3657: stmt_num := 5;
3658: BEGIN
3659: SELECT 'Is pointing to a common'
3660: INTO dummy
3661: FROM bom_bill_of_materials
3662: WHERE bill_sequence_id = c1rec.BSI
3663: AND common_bill_sequence_id <> c1rec.BSI;
3664:
3665: ret_code := INVPUOPI.mtl_log_interface_err(

Line 3698: FROM bom_bill_of_materials bbom

3694: stmt_num := 6;
3695: BEGIN
3696: SELECT 1
3697: INTO dummy
3698: FROM bom_bill_of_materials bbom
3699: WHERE bbom.common_bill_sequence_id = c1rec.BSI
3700: AND bbom.organization_id <> bbom.common_organization_id
3701: AND not exists
3702: (SELECT null

Line 3746: FROM bom_bill_of_materials

3742: stmt_num := 7;
3743: DECLARE
3744: CURSOR CheckBOM IS
3745: SELECT assembly_type
3746: FROM bom_bill_of_materials
3747: WHERE bill_sequence_id = c1rec.BSI;
3748: BEGIN
3749: eng_bill := null;
3750: FOR X_bill IN CheckBOM LOOP

Line 4596: bom_bill_of_materials bom,

4592: msi2.bom_item_type BIT, msi1.bom_item_type CBIT,
4593: bom.assembly_item_id AII,
4594: bic.operation_lead_time_percent OLTP --1851537
4595: FROM
4596: bom_bill_of_materials bom,
4597: mtl_system_items msi1,
4598: mtl_system_items msi2,
4599: bom_inventory_comps_interface bic
4600: WHERE bic.process_flag = 4