APPS.BOM_EXPLODER_PUB dependencies on BOM_STRUCTURE_TYPES_B

Line 464: FROM BOM_STRUCTURE_TYPES_B bst1

460: AND ATDOCS.CATEGORY_ID IN
461: ( SELECT BIA.attach_category_id FROM BOM_ITEM_ATTACH_CATEGORY_ASSOC BIA
462: WHERE BIA.STRUCTURE_TYPE_ID IN
463: ( SELECT bst1.structure_type_id
464: FROM BOM_STRUCTURE_TYPES_B bst1
465: CONNECT BY PRIOR bst1.parent_structure_type_id = bst1.structure_type_id
466: START WITH bst1.structure_type_id =
467: ( select strb.structure_type_id
468: from bom_structures_b strb

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

1183: AND (p_impl_flag = 2 OR (p_impl_flag = 1 AND mir.implementation_date IS NOT NULL) )
1184: ORDER BY mir.effectivity_date DESC;
1185:
1186: CURSOR checkPkgHkyStructureType (p_structure_type_id IN NUMBER) IS
1187: SELECT nvl(max(structure_type_id),-1) structure_type_id FROM bom_structure_types_b WHERE structure_type_name ='Packaging Hierarchy'
1188: AND structure_type_id = p_structure_type_id;
1189:
1190: CURSOR c_Pkg_Structure_Type IS
1191: SELECT structure_type_id

Line 1192: FROM bom_structure_types_b

1188: AND structure_type_id = p_structure_type_id;
1189:
1190: CURSOR c_Pkg_Structure_Type IS
1191: SELECT structure_type_id
1192: FROM bom_structure_types_b
1193: WHERE structure_type_name = 'Packaging Hierarchy';
1194:
1195: CURSOR getItemRevDetails (p_revision_id IN NUMBER) IS
1196: SELECT

Line 2761: FROM bom_structure_types_b

2757: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id );
2758:
2759: CURSOR c_Pkg_Structure_Type IS
2760: SELECT structure_type_id
2761: FROM bom_structure_types_b
2762: WHERE structure_type_name = 'Packaging Hierarchy';
2763:
2764: CURSOR getComponentFixedRevisions (p_group_id IN NUMBER) IS
2765: SELECT bet.component_sequence_id, bet.component_item_revision_id revision_id,