DBA Data[Home] [Help]

APPS.BOMPASGB dependencies on BOM_BILL_OF_MATERIALS

Line 1178: from bom_bill_of_materials

1174:
1175: BEGIN
1176: select bill_sequence_id
1177: into bill_seq_id
1178: from bom_bill_of_materials
1179: where organization_id = org_id
1180: and assembly_item_id = item_id
1181: and nvl(alternate_bom_designator, 'NONE') =
1182: nvl(alt_desg, 'NONE');

Line 1321: from bom_bill_of_materials

1317:
1318: BEGIN
1319: select assembly_item_id, organization_id, alternate_bom_designator
1320: into item_id, org_id, alt_desg
1321: from bom_bill_of_materials
1322: where bill_sequence_id = bill_seq_id;
1323: return(0);
1324: EXCEPTION
1325: when NO_DATA_FOUND then