APPS.ASO_QUOTE_TMPL_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 105: FROM MTL_SYSTEM_ITEMS_VL

101: l_qte_organization_id number;
102:
103: CURSOR c_conc_segments (l_inventory_item_id NUMBER) IS
104: SELECT concatenated_segments
105: FROM MTL_SYSTEM_ITEMS_VL
106: WHERE inventory_item_id = l_inventory_item_id;
107:
108: CURSOR c_config_lines (l_quote_line_id NUMBER) IS
109: SELECT A.quote_line_id

Line 120: FROM MTL_SYSTEM_ITEMS_VL

116: WHERE service_ref_line_id = l_quote_line_id;
117:
118: CURSOR c_service_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
119: SELECT service_item_flag
120: FROM MTL_SYSTEM_ITEMS_VL
121: WHERE inventory_item_id = l_inventory_item_id
122: AND organization_id = l_organization_id;
123:
124: CURSOR c_get_org_id ( l_qte_hdr_id NUMBER) IS

Line 688: FROM MTL_SYSTEM_ITEMS_VL

684: ) RETURN BOOLEAN
685: is
686: CURSOR c_conc_segments (l_inventory_item_id NUMBER) IS
687: SELECT concatenated_segments
688: FROM MTL_SYSTEM_ITEMS_VL
689: WHERE inventory_item_id = l_inventory_item_id;
690:
691: CURSOR c_orderable_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
692: SELECT bom_item_type,

Line 695: FROM MTL_SYSTEM_ITEMS_VL

691: CURSOR c_orderable_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
692: SELECT bom_item_type,
693: primary_uom_code,
694: service_item_flag
695: FROM MTL_SYSTEM_ITEMS_VL
696: WHERE inventory_item_id = l_inventory_item_id
697: AND organization_id = l_organization_id
698: AND customer_order_enabled_flag = 'Y'
699: AND bom_item_type <> 2

Line 705: from mtl_system_items_vl

701: AND NVL(end_date_active, SYSDATE) >= SYSDATE;
702:
703: cursor c_in_org_in_master_org(l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
704: select segment1
705: from mtl_system_items_vl
706: WHERE inventory_item_id = l_inventory_item_id
707: AND organization_id = l_organization_id;
708:
709: l_conc_segments VARCHAR2(40);