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 1981: from mtl_system_items_vl MSIV

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

Line 2062: FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES mic

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

Line 2206: FROM mtl_system_items_vl MSIV

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

Line 2515: from mtl_system_items_vl MSIV

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

Line 2703: FROM mtl_system_items_vl MSIV

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

Line 3040: from MTL_SYSTEM_ITEMS_VL MSIV

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