APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_STRUCTURE_TYPES_B

Line 520: l_existing_str_type BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_NAME%TYPE;

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');
519:
520: l_existing_str_type BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_NAME%TYPE;
521:
522: BEGIN
523:
524: --

Line 550: SELECT structure_type_id INTO struct_type_id FROM bom_structure_types_b

546: END IF;
547:
548: -- PackBom Related validations ..
549:
550: SELECT structure_type_id INTO struct_type_id FROM bom_structure_types_b
551: WHERE structure_type_name = 'Packaging Hierarchy';
552:
553: IF p_bom_head_unexp_rec.structure_type_id = struct_type_id
554: THEN

Line 668: FROM BOM_STRUCTURE_TYPES_B BST

664: BAD.ORGANIZATION_ID = p_bom_head_unexp_rec.organization_id
665: AND BAD.ALTERNATE_DESIGNATOR_CODE = p_bom_header_rec.alternate_bom_code
666: AND BAD.STRUCTURE_TYPE_ID IN
667: ( SELECT BST.STRUCTURE_TYPE_ID
668: FROM BOM_STRUCTURE_TYPES_B BST
669: START WITH BST.STRUCTURE_TYPE_ID = p_bom_head_unexp_rec.structure_type_id
670: CONNECT BY PRIOR BST.PARENT_STRUCTURE_TYPE_ID = BST.STRUCTURE_TYPE_ID
671: );
672:

Line 698: FROM BOM_STRUCTURE_TYPES_B BST

694: AND p_bom_head_unexp_rec.structure_type_id <> p_old_bom_head_unexp_rec.structure_type_id )
695: THEN
696: SELECT COUNT(1)
697: INTO l_count
698: FROM BOM_STRUCTURE_TYPES_B BST
699: WHERE BST.STRUCTURE_TYPE_ID = p_bom_head_unexp_rec.structure_type_id
700: START WITH BST.STRUCTURE_TYPE_ID = p_old_bom_head_unexp_rec.structure_type_id
701: CONNECT BY PRIOR BST.STRUCTURE_TYPE_ID = BST.PARENT_STRUCTURE_TYPE_ID;
702:

Line 711: FROM BOM_STRUCTURE_TYPES_B

707: l_token_tbl(1).token_name := 'OLD_STRTYPE';
708: BEGIN
709: SELECT STRUCTURE_TYPE_NAME
710: INTO l_existing_str_type
711: FROM BOM_STRUCTURE_TYPES_B
712: WHERE STRUCTURE_TYPE_ID = p_old_bom_head_unexp_rec.structure_type_id;
713:
714: l_token_tbl(1).token_value := l_existing_str_type;
715: EXCEPTION