DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on BOM_STRUCTURE_TYPES_VL

Line 1554: FROM bom_structure_types_vl st

1550: IS
1551: CURSOR c_structure_type(l_bill_sequence_id NUMBER
1552: ) IS
1553: SELECT display_name
1554: FROM bom_structure_types_vl st
1555: , bom_structures_b bsb
1556: WHERE bsb.bill_sequence_id = l_bill_sequence_id
1557: and bsb.structure_type_id = st.structure_type_id;
1558:

Line 1838: FROM bom_structure_types_vl

1834: l_GTIN_Id NUMBER;
1835: BEGIN
1836: SELECT Structure_Type_Id
1837: INTO l_GTIN_Id
1838: FROM bom_structure_types_vl
1839: WHERE Structure_Type_Name ='Packaging Hierarchy'
1840: AND Structure_Type_Id = p_Structure_Type_Id;
1841:
1842: RETURN TRUE;