APPS.IBE_CATALOG_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 99: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_VL MSIV ' ||

95: L_MSIV_STMT CONSTANT VARCHAR2(2000) :=
96: 'SELECT si.inventory_item_id, si.organization_id, si.usage_name, MSIV.web_status, ' ||
97: ' si.start_date_active assoc_start_dt, si.end_date_active assoc_end_dt, ' ||
98: ' MSIV.start_date_active start_dt, MSIV.end_date_active end_dt ' ||
99: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_VL MSIV ' ||
100: 'WHERE si.section_id = :sect_id ' ||
101: 'AND si.inventory_item_id = MSIV.inventory_item_id ' ||
102: 'AND si.organization_id = MSIV.organization_id ' ||
103: 'AND (MSIV.WEB_STATUS = ''PUBLISHED'' OR MSIV.WEB_STATUS = ''UNPUBLISHED'') ' ||

Line 1286: 'FROM MTL_SYSTEM_ITEMS_VL MSIV ';

1282: 'MSIV.CONCATENATED_SEGMENTS, MSIV.INVENTORY_ITEM_ID, '||
1283: --gzhang 10/24/2002, ER#2474216
1284: 'MSIV.SERVICE_ITEM_FLAG,MSIV.SERVICEABLE_PRODUCT_FLAG,MSIV.SERVICE_DURATION_PERIOD_CODE,MSIV.SERVICE_DURATION, '||
1285: 'MSIV.SHIPPABLE_ITEM_FLAG,MSIV.INVOICEABLE_ITEM_FLAG,MSIV.INVOICE_ENABLED_FLAG, MSIV.START_DATE_ACTIVE, MSIV.END_DATE_ACTIVE '||
1286: 'FROM MTL_SYSTEM_ITEMS_VL MSIV ';
1287:
1288:
1289: L_BASIC_DEEP_QUERY CONSTANT VARCHAR2(2100) :=
1290: 'SELECT MSIV.CONFIG_MODEL_TYPE, MSIV.BOM_ENABLED_FLAG, MSIV.ORDERABLE_ON_WEB_FLAG, MSIV.BACK_ORDERABLE_FLAG, ' ||

Line 1313: 'MSIV.GLOBAL_ATTRIBUTE9, MSIV.GLOBAL_ATTRIBUTE10 FROM MTL_SYSTEM_ITEMS_VL MSIV ';

1309: 'MSIV.COUPON_EXEMPT_FLAG, MSIV.VOL_DISCOUNT_EXEMPT_FLAG, MSIV.ELECTRONIC_FLAG, ' ||
1310: 'MSIV.GLOBAL_ATTRIBUTE_CATEGORY, ' ||
1311: 'MSIV.GLOBAL_ATTRIBUTE1, MSIV.GLOBAL_ATTRIBUTE2, MSIV.GLOBAL_ATTRIBUTE3, MSIV.GLOBAL_ATTRIBUTE4, ' ||
1312: 'MSIV.GLOBAL_ATTRIBUTE5, MSIV.GLOBAL_ATTRIBUTE6, MSIV.GLOBAL_ATTRIBUTE7, MSIV.GLOBAL_ATTRIBUTE8, ' ||
1313: 'MSIV.GLOBAL_ATTRIBUTE9, MSIV.GLOBAL_ATTRIBUTE10 FROM MTL_SYSTEM_ITEMS_VL MSIV ';
1314:
1315:
1316: L_BASIC_DEEP_ONLY_QUERY CONSTANT VARCHAR2(2000) := --gzhang 10/24/2002, ER#2474216
1317: 'SELECT MSIV.TAXABLE_FLAG, MSIV.ATP_FLAG, MSIV.RETURNABLE_FLAG, ' ||

Line 1331: 'MSIV.INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_VL MSIV ';

1327: 'MSIV.GLOBAL_ATTRIBUTE_CATEGORY, ' ||
1328: 'MSIV.GLOBAL_ATTRIBUTE1, MSIV.GLOBAL_ATTRIBUTE2, MSIV.GLOBAL_ATTRIBUTE3, MSIV.GLOBAL_ATTRIBUTE4, ' ||
1329: 'MSIV.GLOBAL_ATTRIBUTE5, MSIV.GLOBAL_ATTRIBUTE6, MSIV.GLOBAL_ATTRIBUTE7, MSIV.GLOBAL_ATTRIBUTE8, ' ||
1330: 'MSIV.GLOBAL_ATTRIBUTE9, MSIV.GLOBAL_ATTRIBUTE10, MSIV.CONCATENATED_SEGMENTS, ' ||
1331: 'MSIV.INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_VL MSIV ';
1332:
1333: BEGIN
1334: IF p_load_level = G_ITEM_SHALLOW THEN
1335: x_basic_query := L_BASIC_SHALLOW_QUERY;

Line 1350: -- MTL_SYSTEM_ITEMS_VL and appends 'MSIV.' in front of each column name so

1346: -- Start of comments
1347: -- API name : Process_Order_By_Clause
1348: -- Type : Private.
1349: -- Function : Takes comma separated list of columns (with option asc or desc) of
1350: -- MTL_SYSTEM_ITEMS_VL and appends 'MSIV.' in front of each column name so
1351: -- it can be used in the order by clause of a query that joins with
1352: -- MTL_SYSTEM_ITEMS_VL.
1353: -- Pre-reqs : None.
1354: -- Parameters :

Line 1352: -- MTL_SYSTEM_ITEMS_VL.

1348: -- Type : Private.
1349: -- Function : Takes comma separated list of columns (with option asc or desc) of
1350: -- MTL_SYSTEM_ITEMS_VL and appends 'MSIV.' in front of each column name so
1351: -- it can be used in the order by clause of a query that joins with
1352: -- MTL_SYSTEM_ITEMS_VL.
1353: -- Pre-reqs : None.
1354: -- Parameters :
1355: -- IN : p_order_by_clause IN VARCHAR2
1356: --

Line 1982: from mtl_system_items_vl MSIV

1978: l_api_version CONSTANT NUMBER := 1.0;
1979:
1980: cursor l_itmid_csr(p_item_partnum VARCHAR2) IS
1981: select MSIV.inventory_item_id
1982: from mtl_system_items_vl MSIV
1983: where MSIV.concatenated_segments = p_item_partnum;
1984:
1985: l_itmid NUMBER;
1986: l_itm_stmt VARCHAR2(32767);

Line 2063: FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES mic

2059: -- open category id cursor for return if category set id is not null
2060: IF (p_category_set_id IS NOT NULL) THEN
2061: OPEN x_category_id_csr FOR
2062: SELECT MSIV.INVENTORY_ITEM_ID, mic.CATEGORY_ID
2063: FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES mic
2064: WHERE MSIV.INVENTORY_ITEM_ID = l_itmid
2065: AND MSIV.ORGANIZATION_ID = p_organization_id
2066: AND NVL(MSIV.START_DATE_ACTIVE, SYSDATE) <= SYSDATE
2067: AND NVL(MSIV.END_DATE_ACTIVE, SYSDATE) >= SYSDATE

Line 2207: FROM mtl_system_items_vl MSIV

2203: ORDER BY miuv.UOM_CODE;
2204:
2205: CURSOR l_primary_uom_csr IS
2206: SELECT MSIV.primary_uom_code
2207: FROM mtl_system_items_vl MSIV
2208: WHERE MSIV.inventory_item_id = p_itmid;
2209:
2210: l_retrieve_all_uom VARCHAR2(10);
2211: l_primary_uom VARCHAR2(40);

Line 2516: from mtl_system_items_vl MSIV

2512: l_ui_def_id NUMBER;
2513:
2514: cursor l_itmid_csr(l_partnum VARCHAR2) IS
2515: select MSIV.inventory_item_id
2516: from mtl_system_items_vl MSIV
2517: where MSIV.concatenated_segments = l_partnum;
2518:
2519: cursor l_category_id_csr(l_itmid NUMBER,
2520: l_organization_id NUMBER,

Line 2704: FROM mtl_system_items_vl MSIV

2700: idx BINARY_INTEGER;
2701:
2702: CURSOR l_primary_uom_csr(l_item_id NUMBER) IS
2703: SELECT MSIV.primary_uom_code
2704: FROM mtl_system_items_vl MSIV
2705: WHERE MSIV.inventory_item_id = l_item_id;
2706:
2707: CURSOR l_uom_csr(l_item_id NUMBER) IS
2708: SELECT miuv.UOM_CODE

Line 3041: from MTL_SYSTEM_ITEMS_VL MSIV

3037: l_temp_key CONSTANT VARCHAR2(20) := 'ITEMIDS_TYPECODE';
3038: l_init_msg_list VARCHAR2(5);
3039: cursor l_itm_attr_csr(l_temp_key VARCHAR2, l_org_id NUMBER) IS
3040: select MSIV.SERVICE_ITEM_FLAG,MSIV.SERVICEABLE_PRODUCT_FLAG
3041: from MTL_SYSTEM_ITEMS_VL MSIV
3042: where MSIV.INVENTORY_ITEM_ID IN (select NUM_VAL from IBE_TEMP_TABLE where key =
3043: l_temp_key ) and MSIV.ORGANIZATION_ID = l_org_id;
3044:
3045: BEGIN