eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_HZ_PLAN dependencies on MSC_SUP_DEM_ENTRIES_UI_V

Line 1572: l_statement := ' FROM msc_sup_dem_entries_ui_v';

1568:
1569: l_sel_count := ' SELECT COUNT(distinct customer_site_id), COUNT(distinct supplier_site_id) ';
1570: l_sel_cust_site := ' SELECT distinct customer_site_id, customer_id ';
1571: l_sel_sup_site := ' SELECT distinct supplier_site_id, supplier_id ';
1572: l_statement := ' FROM msc_sup_dem_entries_ui_v';
1573: l_statement := l_statement || ' WHERE plan_id = -1 AND PUBLISHER_ORDER_TYPE IN (';
1574: l_statement := l_statement || l_orders;
1575: l_statement := l_statement || ') ' ;
1576: l_statement := l_statement || ' AND NVL(KEY_DATE, SYSDATE + 99999) >= to_date(''' || l_date || ''', ''MM-DD-YYYY'') ';

Line 2003: --msc_sup_dem_entries_ui_v b

1999: -- var_cust/supp_site can be list of id concatenated by ',' eg '34,45'
2000: cursor security_check
2001: is select 1
2002: from msc_sup_dem_update_security_v a --,
2003: --msc_sup_dem_entries_ui_v b
2004: where --a.transaction_id = b.transaction_id
2005: a.customer_id = previous_rec.customer_id
2006: and a.customer_site_id = previous_rec.cust_site_id
2007: and a.supplier_id = previous_rec.supplier_id

Line 2182: from msc_sup_dem_entries_ui_v

2178:
2179: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2180: customer_id, tp_quantity,
2181: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2182: from msc_sup_dem_entries_ui_v
2183: where base_item_id = activity_rec.item_id
2184: and customer_id = activity_rec.customer_id
2185: and customer_site_id = activity_rec.cust_site_id
2186: and supplier_id = activity_rec.supplier_id

Line 2195: from msc_sup_dem_entries_ui_v

2191:
2192: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2193: customer_id, tp_quantity,
2194: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2195: from msc_sup_dem_entries_ui_v
2196: where inventory_item_id = activity_rec.item_id
2197: and customer_id = activity_rec.customer_id
2198: and customer_site_id = activity_rec.cust_site_id
2199: and supplier_id = activity_rec.supplier_id

Line 2213: from msc_sup_dem_entries_ui_v

2209:
2210: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2211: customer_id, tp_quantity,
2212: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2213: from msc_sup_dem_entries_ui_v
2214: where base_item_id= activity_rec.item_id
2215: and customer_id = activity_rec.customer_id
2216: and supplier_id = activity_rec.supplier_id
2217: and supplier_site_id = activity_rec.supp_site_id

Line 2224: from msc_sup_dem_entries_ui_v

2220:
2221: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2222: customer_id, tp_quantity,
2223: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2224: from msc_sup_dem_entries_ui_v
2225: where inventory_item_id = activity_rec.item_id
2226: and customer_id = activity_rec.customer_id
2227: and supplier_id = activity_rec.supplier_id
2228: and supplier_site_id = activity_rec.supp_site_id

Line 2239: from msc_sup_dem_entries_ui_v

2235:
2236: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2237: customer_id, tp_quantity,
2238: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2239: from msc_sup_dem_entries_ui_v
2240: where base_item_id = activity_rec.item_id
2241: and customer_id = activity_rec.customer_id
2242: and customer_site_id = activity_rec.cust_site_id
2243: and supplier_id = activity_rec.supplier_id

Line 2250: from msc_sup_dem_entries_ui_v

2246:
2247: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2248: customer_id, tp_quantity,
2249: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2250: from msc_sup_dem_entries_ui_v
2251: where inventory_item_id = activity_rec.item_id
2252: and customer_id = activity_rec.customer_id
2253: and customer_site_id = activity_rec.cust_site_id
2254: and supplier_id = activity_rec.supplier_id

Line 2272: from msc_sup_dem_entries_ui_v

2268:
2269: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2270: customer_id, tp_quantity,
2271: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2272: from msc_sup_dem_entries_ui_v
2273: where base_item_id = activity_rec.item_id
2274: and customer_id = activity_rec.customer_id
2275: and supplier_id = activity_rec.supplier_id
2276: and supplier_site_id = activity_rec.supp_site_id

Line 2283: from msc_sup_dem_entries_ui_v

2279:
2280: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2281: customer_id, tp_quantity,
2282: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2283: from msc_sup_dem_entries_ui_v
2284: where inventory_item_id = activity_rec.item_id
2285: and customer_id = activity_rec.customer_id
2286: and supplier_id = activity_rec.supplier_id
2287: and supplier_site_id = activity_rec.supp_site_id

Line 2298: from msc_sup_dem_entries_ui_v

2294:
2295: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2296: customer_id, tp_quantity,
2297: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2298: from msc_sup_dem_entries_ui_v
2299: where base_item_id = activity_rec.item_id
2300: and customer_id = activity_rec.customer_id
2301: and customer_site_id = activity_rec.cust_site_id
2302: and supplier_id = activity_rec.supplier_id

Line 2309: from msc_sup_dem_entries_ui_v

2305:
2306: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2307: customer_id, tp_quantity,
2308: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2309: from msc_sup_dem_entries_ui_v
2310: where inventory_item_id = activity_rec.item_id
2311: and customer_id = activity_rec.customer_id
2312: and customer_site_id = activity_rec.cust_site_id
2313: and supplier_id = activity_rec.supplier_id

Line 2326: from msc_sup_dem_entries_ui_v

2322:
2323: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2324: customer_id, tp_quantity,
2325: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2326: from msc_sup_dem_entries_ui_v
2327: where base_item_id = activity_rec.item_id
2328: and customer_id = activity_rec.customer_id
2329: and supplier_id = activity_rec.supplier_id
2330: and publisher_order_type = activity_rec.order_type

Line 2336: from msc_sup_dem_entries_ui_v

2332:
2333: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2334: customer_id, tp_quantity,
2335: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2336: from msc_sup_dem_entries_ui_v
2337: where inventory_item_id = activity_rec.item_id
2338: and customer_id = activity_rec.customer_id
2339: and supplier_id = activity_rec.supplier_id
2340: and publisher_order_type = activity_rec.order_type

Line 2357: from msc_sup_dem_entries_ui_v

2353:
2354: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2355: customer_id, tp_quantity,
2356: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2357: from msc_sup_dem_entries_ui_v
2358: where base_item_id = activity_rec.item_id
2359: and customer_id = activity_rec.customer_id
2360: and customer_site_id = activity_rec.cust_site_id
2361: and publisher_order_type = activity_rec.order_type

Line 2368: from msc_sup_dem_entries_ui_v

2364:
2365: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2366: customer_id, tp_quantity,
2367: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2368: from msc_sup_dem_entries_ui_v
2369: where inventory_item_id = activity_rec.item_id
2370: and customer_id = activity_rec.customer_id
2371: and customer_site_id = activity_rec.cust_site_id
2372: and publisher_order_type = activity_rec.order_type

Line 2382: from msc_sup_dem_entries_ui_v

2378:
2379: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2380: customer_id, tp_quantity,
2381: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2382: from msc_sup_dem_entries_ui_v
2383: where base_item_id = activity_rec.item_id
2384: and supplier_id = activity_rec.supplier_id
2385: and supplier_site_id = activity_rec.supp_site_id
2386: and publisher_order_type = activity_rec.order_type

Line 2392: from msc_sup_dem_entries_ui_v

2388:
2389: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2390: customer_id, tp_quantity,
2391: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2392: from msc_sup_dem_entries_ui_v
2393: where inventory_item_id = activity_rec.item_id
2394: and supplier_id = activity_rec.supplier_id
2395: and supplier_site_id = activity_rec.supp_site_id
2396: and publisher_order_type = activity_rec.order_type

Line 2410: from msc_sup_dem_entries_ui_v

2406:
2407: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2408: customer_id, tp_quantity,
2409: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2410: from msc_sup_dem_entries_ui_v
2411: where base_item_id = activity_rec.item_id
2412: and customer_id = activity_rec.customer_id
2413: and publisher_order_type = activity_rec.order_type
2414: and key_date < p_start_date;

Line 2420: from msc_sup_dem_entries_ui_v

2416:
2417: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2418: customer_id, tp_quantity,
2419: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2420: from msc_sup_dem_entries_ui_v
2421: where inventory_item_id = activity_rec.item_id
2422: and customer_id = activity_rec.customer_id
2423: and publisher_order_type = activity_rec.order_type
2424: and key_date < p_start_date;

Line 2432: from msc_sup_dem_entries_ui_v

2428:
2429: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2430: customer_id, tp_quantity,
2431: supplier_id, tp_quantity, quantity)),0) into l_base_qty
2432: from msc_sup_dem_entries_ui_v
2433: where base_item_id = activity_rec.item_id
2434: and supplier_id = activity_rec.supplier_id
2435: and publisher_order_type = activity_rec.order_type
2436: and key_date < p_start_date;

Line 2441: from msc_sup_dem_entries_ui_v

2437:
2438: select nvl(sum(decode (sys_context('MSC','COMPANY_ID'), publisher_id,primary_quantity,
2439: customer_id, tp_quantity,
2440: supplier_id, tp_quantity, quantity)),0) into l_config_qty
2441: from msc_sup_dem_entries_ui_v
2442: where inventory_item_id = activity_rec.item_id
2443: and supplier_id = activity_rec.supplier_id
2444: and publisher_order_type = activity_rec.order_type
2445: and key_date < p_start_date;

Line 2906: l_statement := l_statement || ' FROM msc_sup_dem_entries_ui_v';

2902: l_statement := l_statement || 'SUPPLIER_SITE_ID,CUSTOMER_SITE_ID,';
2903: l_statement := l_statement || 'THIRD_PARTY_FLAG,VIEWER_COMPANY,nvl(TP_COMPANY,-1),';
2904: l_statement := l_statement || 'nvl(BUCKET_TYPE,' || DAY_BUCKET || ')';
2905: l_statement := l_statement || ',PUBLISHER_ID,PUBLISHER_SITE_ID';
2906: l_statement := l_statement || ' FROM msc_sup_dem_entries_ui_v';
2907: l_statement := l_statement || ' WHERE plan_id = -1 AND PUBLISHER_ORDER_TYPE IN (';
2908: l_statement := l_statement || l_orders;
2909: l_statement := l_statement || ') ' ;
2910: l_statement := l_statement || ' AND KEY_DATE >= decode(publisher_order_type, 13, KEY_DATE, 14, KEY_DATE, 15, KEY_DATE, to_date(''' || l_date || ''', ''MM-DD-YYYY'')) ';

Line 3509: from msc_sup_dem_entries_ui_v

3505: FOR i in var_relation.FIRST..var_relation.LAST LOOP
3506: if(var_order(i) = SAFETY_STOCK or var_order(i) = PROJ_AVAIL_BAL) then
3507: BEGIN
3508: select quantity into default_ss
3509: from msc_sup_dem_entries_ui_v
3510: where nvl(base_item_id,inventory_item_id) = var_item_id(i)
3511: and publisher_order_type = 7
3512: and publisher_id = var_pub_id(i)
3513: and publisher_site_id = var_pub_site_id(i)

Line 3524: from msc_sup_dem_entries_ui_v

3520: default_ss := 0;
3521: END;
3522: BEGIN
3523: select quantity into default_pab
3524: from msc_sup_dem_entries_ui_v
3525: where nvl(base_item_id,inventory_item_id) = var_item_id(i)
3526: and publisher_order_type = 8
3527: and publisher_id = var_pub_id(i)
3528: and publisher_site_id = var_pub_site_id(i)

Line 4427: FROM msc_sup_dem_entries_ui_v

4423: uom_code,nvl(tp_uom_code, uom_code) ,owner_item_description,
4424: supplier_item_description,customer_item_description
4425: INTO v_owner_item,v_sup_item,v_cust_item,v_uom_code,v_tp_uom,
4426: v_owner_item_desc,v_sup_item_desc,v_cust_item_desc
4427: FROM msc_sup_dem_entries_ui_v
4428: WHERE inventory_item_id = v_item_id(i)
4429: AND publisher_order_type = v_order(i)
4430: AND publisher_name = v_pub_name(i)
4431: AND customer_name = v_cust_name(i)