APPS.ASO_OPP_QTE_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 205: FROM MTL_SYSTEM_ITEMS_VL

201: WHERE source_code_id = l_sc_id;
202:
203: CURSOR c_conc_segments (l_inventory_item_id NUMBER) IS
204: SELECT concatenated_segments
205: FROM MTL_SYSTEM_ITEMS_VL
206: WHERE inventory_item_id = l_inventory_item_id;
207:
208: CURSOR C_sales_team (l_lead_id NUMBER) IS
209: SELECT salesforce_id,

Line 292: FROM MTL_SYSTEM_ITEMS_VL

288: AND organization_id = p_organization_id;
289:
290: CURSOR c_serv_item (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
291: SELECT service_item_flag,service_duration,service_duration_period_code
292: FROM MTL_SYSTEM_ITEMS_VL
293: WHERE inventory_item_id = l_inventory_item_id
294: AND organization_id = l_organization_id
295: AND customer_order_enabled_flag = 'Y'
296: AND bom_item_type <> 2

Line 1575: FROM MTL_SYSTEM_ITEMS_VL

1571: IS
1572:
1573: CURSOR c_conc_segments (l_inventory_item_id NUMBER) IS
1574: SELECT concatenated_segments
1575: FROM MTL_SYSTEM_ITEMS_VL
1576: WHERE inventory_item_id = l_inventory_item_id;
1577:
1578: CURSOR c_orderable_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
1579: SELECT bom_item_type,

Line 1582: FROM MTL_SYSTEM_ITEMS_VL

1578: CURSOR c_orderable_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
1579: SELECT bom_item_type,
1580: primary_uom_code,
1581: service_item_flag
1582: FROM MTL_SYSTEM_ITEMS_VL
1583: WHERE inventory_item_id = l_inventory_item_id
1584: AND organization_id = l_organization_id
1585: AND customer_order_enabled_flag = 'Y'
1586: AND bom_item_type <> 2

Line 1592: from mtl_system_items_vl

1588: AND NVL(end_date_active, SYSDATE) >= SYSDATE;
1589:
1590: cursor c_in_org_in_master_org(l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
1591: select segment1
1592: from mtl_system_items_vl
1593: WHERE inventory_item_id = l_inventory_item_id
1594: AND organization_id = l_organization_id;
1595:
1596: l_conc_segments VARCHAR2(40);