APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_BILL_OF_MATERIALS

Line 514: FROM bom_bill_of_materials

510:
511: CURSOR c_CheckCommon IS
512: SELECT NVL(common_bill_sequence_id,bill_sequence_id) common_bill_seq,
513: bill_sequence_id
514: FROM bom_bill_of_materials
515: WHERE assembly_item_id = p_bom_head_unexp_rec.assembly_item_id
516: AND organization_id = p_bom_head_unexp_rec.organization_id
517: AND NVL(alternate_bom_designator, 'XXXX') =
518: NVL(p_bom_header_rec.alternate_bom_code, 'XXXX');

Line 622: FROM bom_bill_of_materials

618: THEN
619: BEGIN
620: SELECT '1'
621: INTO l_dummy
622: FROM bom_bill_of_materials
623: WHERE alternate_bom_designator IS NULL
624: AND assembly_item_id =
625: p_bom_head_unexp_rec.assembly_item_id
626: AND organization_id =

Line 836: FROM bom_bill_of_materials

832: THEN
833: BEGIN
834: SELECT '1'
835: INTO l_dummy
836: FROM bom_bill_of_materials
837: WHERE bill_sequence_id =
838: p_bom_head_unexp_rec.source_bill_sequence_id
839: AND NVL(source_bill_sequence_id, bill_sequence_id) <>
840: bill_sequence_id;