APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_BILL_OF_MATERIALS

Line 519: FROM bom_bill_of_materials

515:
516: /* CURSOR c_CheckCommon IS
517: SELECT NVL(common_bill_sequence_id,bill_sequence_id) common_bill_seq,
518: bill_sequence_id
519: FROM bom_bill_of_materials
520: WHERE assembly_item_id = p_bom_head_unexp_rec.assembly_item_id
521: AND organization_id = p_bom_head_unexp_rec.organization_id
522: AND NVL(alternate_bom_designator, 'XXXX') =
523: NVL(p_bom_header_rec.alternate_bom_code, 'XXXX'); */

Line 659: FROM bom_bill_of_materials

655: THEN
656: BEGIN
657: SELECT '1'
658: INTO l_dummy
659: FROM bom_bill_of_materials
660: WHERE alternate_bom_designator IS NULL
661: AND assembly_item_id =
662: p_bom_head_unexp_rec.assembly_item_id
663: AND organization_id =

Line 877: FROM bom_bill_of_materials

873: THEN
874: BEGIN
875: SELECT '1'
876: INTO l_dummy
877: FROM bom_bill_of_materials
878: WHERE bill_sequence_id =
879: p_bom_head_unexp_rec.source_bill_sequence_id
880: AND NVL(source_bill_sequence_id, bill_sequence_id) <>
881: bill_sequence_id;