DBA Data[Home] [Help]

APPS.BOM_REFERENCE_DESIGNATOR_API dependencies on BOM_BILL_OF_MATERIALS

Line 253: FROM bom_bill_of_materials

249: IF (c1rec.BSI is null) THEN
250: BEGIN
251: SELECT bill_sequence_id, assembly_type
252: INTO c1rec.BSI, X_dummy
253: FROM bom_bill_of_materials
254: WHERE organization_id = c1rec.OI
255: AND assembly_item_id = c1rec.AII
256: AND nvl(alternate_bom_designator, 'NONE') =
257: nvl(c1rec.ABD, 'NONE');

Line 1087: bom_bill_of_materials bbom,

1083: INTO assy_id_dummy, org_id_dummy, assy_type_dummy,
1084: comp_id_dummy, comp_type, dummy,
1085: X_component_quantity, X_quantity_related
1086: FROM bom_inventory_components bic,
1087: bom_bill_of_materials bbom,
1088: mtl_system_items mtl
1089: WHERE bic.component_sequence_id = c1rec.CSI
1090: AND bic.implementation_date is not null
1091: AND bbom.bill_sequence_id = bic.bill_sequence_id