APPS.BOM_SUBSTITUTE_COMPONENT_API dependencies on BOM_BILL_OF_MATERIALS

Line 367: FROM bom_bill_of_materials

363: IF (c1rec.BSI is null) THEN
364: BEGIN
365: SELECT bill_sequence_id, assembly_type
366: INTO c1rec.BSI, X_dummy
367: FROM bom_bill_of_materials
368: WHERE organization_id = c1rec.OI
369: AND assembly_item_id = c1rec.AII
370: AND nvl(alternate_bom_designator, 'NONE') =
371: nvl(c1rec.ABD, 'NONE');

Line 844: bom_bill_of_materials bbom,

840: bbom.assembly_item_id AII, bbom.assembly_type AST,
841: bic.component_item_id CII,
842: bsci.change_notice CN
843: FROM bom_inventory_components bic,
844: bom_bill_of_materials bbom,
845: bom_sub_comps_interface bsci
846: WHERE bsci.process_flag = 2
847: AND bsci.transaction_type in (G_Insert, G_Update)
848: AND (UPPER(bsci.interface_entity_type) = 'BILL'

Line 1046: bom_bill_of_materials bbom,

1042: bic.bom_item_type, mtl.bom_item_type
1043: INTO assy_id_dummy, org_id_dummy, assy_type_dummy,
1044: comp_id_dummy, comp_type, dummy
1045: FROM bom_inventory_components bic,
1046: bom_bill_of_materials bbom,
1047: mtl_system_items mtl
1048: WHERE bic.component_sequence_id = c1rec.CSI
1049: AND bic.implementation_date is not null
1050: AND bbom.bill_sequence_id = bic.bill_sequence_id

Line 1207: FROM bom_bill_of_materials bbom

1203: IF (c3rec.TT = G_Insert
1204: OR (c3rec.TT = G_Update AND c3rec.NSCI is not null)) THEN
1205: SELECT 1
1206: INTO dummy
1207: FROM bom_bill_of_materials bbom
1208: WHERE bbom.common_bill_sequence_id = c3rec.BSI
1209: AND bbom.organization_id <> bbom.common_organization_id
1210: AND not exists
1211: (SELECT null