APPS.BOM_EXPLODER_PUB dependencies on BOM_STRUCTURE_TYPES_B

Line 476: FROM BOM_STRUCTURE_TYPES_B bst1

472: AND ATDOCS.CATEGORY_ID IN
473: ( SELECT BIA.attach_category_id FROM BOM_ITEM_ATTACH_CATEGORY_ASSOC BIA
474: WHERE BIA.STRUCTURE_TYPE_ID IN
475: ( SELECT bst1.structure_type_id
476: FROM BOM_STRUCTURE_TYPES_B bst1
477: CONNECT BY PRIOR bst1.parent_structure_type_id = bst1.structure_type_id
478: START WITH bst1.structure_type_id =
479: ( select strb.structure_type_id
480: from bom_structures_b strb

Line 1267: SELECT nvl(max(structure_type_id),-1) structure_type_id FROM bom_structure_types_b WHERE structure_type_name ='Packaging Hierarchy'

1263: AND (p_impl_flag = 2 OR (p_impl_flag = 1 AND mir.implementation_date IS NOT NULL) )
1264: ORDER BY mir.effectivity_date DESC;
1265:
1266: CURSOR checkPkgHkyStructureType (p_structure_type_id IN NUMBER) IS
1267: SELECT nvl(max(structure_type_id),-1) structure_type_id FROM bom_structure_types_b WHERE structure_type_name ='Packaging Hierarchy'
1268: AND structure_type_id = p_structure_type_id;
1269:
1270: CURSOR c_Pkg_Structure_Type IS
1271: SELECT structure_type_id

Line 1272: FROM bom_structure_types_b

1268: AND structure_type_id = p_structure_type_id;
1269:
1270: CURSOR c_Pkg_Structure_Type IS
1271: SELECT structure_type_id
1272: FROM bom_structure_types_b
1273: WHERE structure_type_name = 'Packaging Hierarchy';
1274:
1275: CURSOR getItemRevDetails (p_revision_id IN NUMBER) IS
1276: SELECT

Line 2851: FROM bom_structure_types_b

2847: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id );
2848:
2849: CURSOR c_Pkg_Structure_Type IS
2850: SELECT structure_type_id
2851: FROM bom_structure_types_b
2852: WHERE structure_type_name = 'Packaging Hierarchy';
2853:
2854: CURSOR getComponentFixedRevisions (p_group_id IN NUMBER) IS
2855: SELECT bet.component_sequence_id, bet.component_item_revision_id revision_id,