APPS.EGO_IMPORT_BATCHES_PKG dependencies on BOM_STRUCTURE_TYPES_B

Line 435: FROM bom_structure_types_b

431: SELECT USER_ID FROM ego_user_v where UPPER(user_NAME) = v_user_name;
432:
433: Cursor Ego_Structure_Id_Name_Csr(v_structure_type_name in VARCHAR2) IS
434: SELECT STRUCTURE_TYPE_ID
435: FROM bom_structure_types_b
436: WHERE STRUCTURE_TYPE_NAME = v_structure_type_name;
437:
438: Cursor Ego_Structure_Type_Csr(v_structure_type_id IN NUMBER, v_master_org_id IN NUMBER) IS
439: SELECT DISPLAY_NAME

Line 448: FROM BOM_STRUCTURE_TYPES_B bst

444: BOM_STRUCTURE_TYPES_VL bsvl
445: WHERE bad.alternate_designator_code IS NOT NULL
446: AND bad.structure_type_id IN
447: (SELECT bst.structure_type_id
448: FROM BOM_STRUCTURE_TYPES_B bst
449: START WITH bst.structure_type_id = v_structure_type_id
450: CONNECT BY PRIOR bst.parent_structure_type_id =
451: bst.structure_type_id)
452: UNION

Line 456: FROM BOM_STRUCTURE_TYPES_B b

452: UNION
453: SELECT bom_globals.retrieve_message('BOM', 'BOM_PRIMARY') DISPLAY_NAME,
454: BOM_Globals.GET_PRIMARY_UI() ALTERNATE_DESIGNATOR_CODE,
455: structure_type_iD
456: FROM BOM_STRUCTURE_TYPES_B b
457: WHERE structure_type_name = 'All-Structure Types') QRSLT
458: WHERE ((ALTERNATE_DESIGNATOR_CODE = BOM_Globals.GET_PRIMARY_UI() OR
459: ALTERNATE_DESIGNATOR_CODE IN
460: (SELECT DISTINCT ALTERNATE_DESIGNATOR_CODE

Line 466: FROM bom_structure_types_b

462: WHERE p.master_organization_id = v_master_org_id
463: AND b.ORGANIZATION_ID = p.organization_id)) AND
464: ((v_structure_type_id =
465: (Select Structure_Type_id
466: FROM bom_structure_types_b
467: where structure_type_name = 'Packaging Hierarchy') AND
468: ALTERNATE_DESIGNATOR_CODE IN
469: (SELECT ALTERNATE_DESIGNATOR_CODE
470: FROM BOM_ALTERNATE_DESIGNATORS b1

Line 476: FROM bom_structure_types_b

472: and is_preferred = 'Y')) OR
473: (v_structure_type_id IS NULL OR
474: v_structure_type_id <>
475: (Select Structure_Type_id
476: FROM bom_structure_types_b
477: where structure_type_name = 'Packaging Hierarchy'))));
478:
479: Cursor Change_Order_Category_Csr(v_change_mgmt_type_code IN VARCHAR2) IS
480: select type_name,