APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on BOM_BILL_OF_MATERIALS

Line 975: FROM bom_bill_of_materials

971: THEN
972: RETURN NULL;
973: ELSE
974: SELECT bill_sequence_id INTO l_bom_sequence_id
975: FROM bom_bill_of_materials
976: WHERE organization_id = p_organization_id
977: AND assembly_item_id = p_assembly_item_id
978: AND ( (alternate_bom_designator IS NULL AND p_alternate_bom_designator IS NULL)
979: OR alternate_bom_designator = p_alternate_bom_designator);

Line 1627: from bom_bill_of_materials

1623: return boolean is
1624: l_count number;
1625: begin
1626: select count(1) into l_count
1627: from bom_bill_of_materials
1628: where assembly_item_id = p_inventory_item_id and
1629: organization_id = p_org_id;
1630:
1631: if l_count > 0 then