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 224: bom_structures_b bsb, bom_structure_types_b bstb

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

Line 232: SELECT bill_sequence_id INTO l_bill_sequence_id FROM bom_structures_b WHERE

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

Line 377: bom_structures_b

373: IS
374: SELECT
375: alternate_bom_designator
376: FROM
377: bom_structures_b
378: WHERE
379: assembly_item_id = p_assembly_item_id
380: AND organization_id = p_organization_id
381: AND alternate_bom_designator = p_structure_name