APPS.BOM_GTIN_RULES dependencies on BOM_STRUCTURES_B

Line 57: FROM bom_structures_b

53: RETURN VARCHAR2 IS
54:
55: CURSOR Pack_Exist IS
56: SELECT bill_sequence_id
57: FROM bom_structures_b
58: WHERE assembly_item_id = p_item_id
59: AND organization_id = p_org_id
60: AND alternate_bom_designator = 'PIM_PBOM_S';
61:

Line 227: bom_structures_b bsb, bom_structure_types_b bstb

223: THEN
224: SELECT
225: bill_sequence_id INTO l_bill_sequence_id
226: FROM
227: bom_structures_b bsb, bom_structure_types_b bstb
228: WHERE
229: assembly_item_id = p_assembly_item_id
230: AND organization_id = p_organization_id
231: AND bsb.structure_type_id = bstb.structure_type_id

Line 235: SELECT bill_sequence_id INTO l_bill_sequence_id FROM bom_structures_b WHERE

231: AND bsb.structure_type_id = bstb.structure_type_id
232: AND bstb.structure_type_name = 'Packaging Hierarchy'
233: AND bsb.is_preferred = 'Y';
234: ELSE
235: SELECT bill_sequence_id INTO l_bill_sequence_id FROM bom_structures_b WHERE
236: assembly_item_id = p_assembly_item_id AND
237: organization_id = p_organization_id AND
238: alternate_bom_designator = p_alternate_bom_code ;
239: END IF;

Line 380: bom_structures_b

376: IS
377: SELECT
378: alternate_bom_designator
379: FROM
380: bom_structures_b
381: WHERE
382: assembly_item_id = p_assembly_item_id
383: AND organization_id = p_organization_id
384: AND alternate_bom_designator = p_structure_name