DBA Data[Home] [Help]

APPS.ASO_QUOTE_TMPL_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 98: FROM MTL_SYSTEM_ITEMS_VL

94:
95:
96: CURSOR c_conc_segments (l_inventory_item_id NUMBER) IS
97: SELECT concatenated_segments
98: FROM MTL_SYSTEM_ITEMS_VL
99: WHERE inventory_item_id = l_inventory_item_id;
100:
101: CURSOR c_config_lines (l_quote_line_id NUMBER) IS
102: SELECT A.quote_line_id

Line 113: FROM MTL_SYSTEM_ITEMS_VL

109: WHERE service_ref_line_id = l_quote_line_id;
110:
111: CURSOR c_service_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
112: SELECT service_item_flag
113: FROM MTL_SYSTEM_ITEMS_VL
114: WHERE inventory_item_id = l_inventory_item_id
115: AND organization_id = l_organization_id;
116:
117: CURSOR c_get_org_id ( l_qte_hdr_id NUMBER) IS