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_EXCHANGE_BUCKETING dependencies on MSC_SUP_DEM_ENTRIES

Line 991: msc_sup_dem_entries sd

987: BEGIN
988: select nvl(max(bucket_type), NONE)
989: into l_cust_bkt_type
990: from
991: msc_sup_dem_entries sd
992: where plan_id = -1
993: and sd.sr_instance_id = p_sr_instance_id
994: and sd.publisher_id =p_customer_id
995: and sd.publisher_site_id = p_customer_site_id

Line 1013: msc_sup_dem_entries sd

1009: BEGIN
1010: select nvl(max(bucket_type), NONE)
1011: into l_supp_bkt_type
1012: from
1013: msc_sup_dem_entries sd
1014: where sd.plan_id = -1
1015: and sd.sr_instance_id = p_sr_instance_id
1016: and sd.publisher_id = p_supplier_id
1017: and sd.publisher_site_id = p_supplier_site_id

Line 1032: msc_sup_dem_entries sd

1028: BEGIN
1029: select nvl(max(bucket_type), NONE)
1030: into l_supp_bkt_type
1031: from
1032: msc_sup_dem_entries sd
1033: where sd.plan_id = -1
1034: and sd.sr_instance_id = p_sr_instance_id
1035: and sd.publisher_id = p_supplier_id
1036: and sd.publisher_site_id = p_supplier_site_id

Line 1175: from msc_sup_dem_entries sd

1171: lv_data_exists number := 2;
1172:
1173: CURSOR sup_planning IS
1174: select 1
1175: from msc_sup_dem_entries sd
1176: where sd.plan_id = -1
1177: and sd.sr_instance_id = p_sr_instance_id
1178: and sd.publisher_id = p_supplier_id
1179: and sd.publisher_site_id = p_supplier_site_id

Line 1189: from msc_sup_dem_entries sd

1185: and to_number(to_char(sd.key_date, 'j')) between p_start_date and p_end_date
1186: and rownum = 1
1187: UNION
1188: select 1
1189: from msc_sup_dem_entries sd
1190: where sd.plan_id = -1
1191: and sd.sr_instance_id = p_sr_instance_id
1192: and sd.publisher_id = p_customer_id
1193: and sd.publisher_site_id = p_customer_site_id

Line 1204: from msc_sup_dem_entries sd

1200: and rownum = 1;
1201:
1202: CURSOR dem_planning IS
1203: select 1
1204: from msc_sup_dem_entries sd
1205: where sd.plan_id = -1
1206: and sd.sr_instance_id = p_sr_instance_id
1207: and sd.publisher_id = p_supplier_id
1208: and sd.publisher_site_id = p_supplier_site_id

Line 1218: from msc_sup_dem_entries sd

1214: and to_number(to_char(sd.key_date, 'j')) between p_start_date and p_end_date
1215: and rownum = 1
1216: UNION
1217: select 1
1218: from msc_sup_dem_entries sd
1219: where sd.plan_id = -1
1220: and sd.sr_instance_id = p_sr_instance_id
1221: and sd.publisher_id = p_customer_id
1222: and sd.publisher_site_id = p_customer_site_id

Line 1312: from msc_sup_dem_entries sd

1308: p_m_end_date in NUMBER,
1309: pCutoff_date in NUMBER,
1310: p_plan_type in NUMBER) is
1311: select to_number(to_char(sd.key_date, 'j')) key_date
1312: from msc_sup_dem_entries sd
1313: where sd.plan_id = -1
1314: and sd.sr_instance_id = p_sr_instance_id
1315: and sd.publisher_id = p_supplier_id
1316: and sd.publisher_site_id = p_supplier_site_id

Line 1328: from msc_sup_dem_entries sd

1324: and to_number(to_char(sd.key_date, 'j')) <= pCutoff_date
1325: and p_plan_type = SUPPLY_PLANNING
1326: UNION
1327: select to_number(to_char(sd.key_date, 'j')) key_date
1328: from msc_sup_dem_entries sd
1329: where sd.plan_id = -1
1330: and sd.sr_instance_id = p_sr_instance_id
1331: and sd.publisher_id = p_customer_id
1332: and sd.publisher_site_id = p_customer_site_id

Line 1344: from msc_sup_dem_entries sd

1340: and to_number(to_char(sd.key_date, 'j')) <= pCutoff_date
1341: and p_plan_type = SUPPLY_PLANNING
1342: UNION
1343: select to_number(to_char(sd.key_date, 'j')) key_date
1344: from msc_sup_dem_entries sd
1345: where sd.plan_id = -1
1346: and sd.sr_instance_id = p_sr_instance_id
1347: and sd.publisher_id = p_supplier_id
1348: and sd.publisher_site_id = p_supplier_site_id

Line 1360: from msc_sup_dem_entries sd

1356: and to_number(to_char(sd.key_date, 'j')) <= pCutoff_date
1357: and p_plan_type = DEMAND_PLANNING
1358: UNION
1359: select to_number(to_char(sd.key_date, 'j')) key_date
1360: from msc_sup_dem_entries sd
1361: where sd.plan_id = -1
1362: and sd.sr_instance_id = p_sr_instance_id
1363: and sd.publisher_id = p_customer_id
1364: and sd.publisher_site_id = p_customer_site_id

Line 1830: msc_sup_dem_entries sd

1826: BEGIN
1827: select nvl(max(sd.last_refresh_number), -1), max(sd.key_date),min(sd.key_date)
1828: into l_max_ref_cust, l_max_receipt_cust, l_min_receipt_cust
1829: from
1830: msc_sup_dem_entries sd
1831: where sd.plan_id = -1
1832: and sd.sr_instance_id = p_sr_instance_id
1833: and sd.publisher_id =p_customer_id
1834: and sd.publisher_site_id = p_customer_site_id

Line 1858: msc_sup_dem_entries sd

1854: select nvl(max(sd.last_refresh_number), -1),
1855: max(sd.key_date),min(sd.key_date)
1856: into l_max_ref_supp, l_max_receipt_supp,l_min_receipt_supp
1857: from
1858: msc_sup_dem_entries sd
1859: where
1860: sd.plan_id = -1
1861: and sd.sr_instance_id = p_sr_instance_id
1862: and sd.publisher_id = p_supplier_id

Line 1880: msc_sup_dem_entries sd

1876: select nvl(max(sd.last_refresh_number), -1),
1877: max(sd.key_date),min(sd.key_date)
1878: into l_max_ref_supp, l_max_receipt_supp,l_min_receipt_supp
1879: from
1880: msc_sup_dem_entries sd
1881: where
1882: sd.plan_id = -1
1883: and sd.sr_instance_id = p_sr_instance_id
1884: and sd.publisher_id = p_supplier_id

Line 1968: from msc_sup_dem_entries sd

1964:
1965: BEGIN
1966: select distinct bucket_type
1967: into l_cust_bucket_type
1968: from msc_sup_dem_entries sd
1969: where sd.plan_id = -1
1970: and sd.sr_instance_id = p_sr_instance_id
1971: and sd.publisher_id =p_customer_id
1972: and sd.publisher_site_id = p_customer_site_id

Line 2011: from msc_sup_dem_entries sd

2007: IF (p_plan_type = SUPPLY_PLANNING) THEN
2008:
2009: BEGIN
2010: select distinct bucket_type into l_supp_bucket_type
2011: from msc_sup_dem_entries sd
2012: where sd.plan_id = -1
2013: and sd.sr_instance_id = p_sr_instance_id
2014: and sd.publisher_id = p_supplier_id
2015: and sd.publisher_site_id = p_supplier_site_id

Line 2029: from msc_sup_dem_entries sd

2025: END;
2026: ELSIF (p_plan_type = DEMAND_PLANNING) THEN
2027: BEGIN
2028: select distinct bucket_type into l_supp_bucket_type
2029: from msc_sup_dem_entries sd
2030: where sd.plan_id = -1
2031: and sd.sr_instance_id = p_sr_instance_id
2032: and sd.publisher_id = p_supplier_id
2033: and sd.publisher_site_id = p_supplier_site_id

Line 2244: FROM msc_sup_dem_entries sd

2240: sd.customer_site_id,
2241: sd.publisher_id supplier_id,
2242: sd.publisher_site_id supplier_site_id,
2243: nvl(sd.base_item_id,sd.inventory_item_id) item_id
2244: FROM msc_sup_dem_entries sd
2245: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2246: AND sd.publisher_order_type in (msc_x_netting_pkg.SUPPLY_COMMIT, msc_x_netting_pkg.SALES_ORDER)
2247: AND sd.last_refresh_number > p_refresh_number
2248: union

Line 2254: FROM msc_sup_dem_entries sd

2250: sd.publisher_site_id customer_site_id,
2251: sd.supplier_id,
2252: sd.supplier_site_id,
2253: nvl(sd.base_item_id,sd.inventory_item_id) item_id
2254: FROM msc_sup_dem_entries sd
2255: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
2256: AND sd.publisher_order_type = msc_x_netting_pkg.ORDER_FORECAST
2257: AND sd.last_refresh_number> p_refresh_number;
2258:

Line 2276: from msc_sup_dem_entries sd1

2272: sd1.supplier_site_id,
2273: nvl(sd1.base_item_id,sd1.inventory_item_id) item_id,
2274: sd1.last_refresh_number,
2275: sd1.key_date
2276: from msc_sup_dem_entries sd1
2277: where sd1.publisher_order_type = 2
2278: and sd1.plan_id= -1
2279: and sd1.last_refresh_number > p_refresh_number
2280: and exists (select 1

Line 2281: from msc_sup_dem_entries sd2

2277: where sd1.publisher_order_type = 2
2278: and sd1.plan_id= -1
2279: and sd1.last_refresh_number > p_refresh_number
2280: and exists (select 1
2281: from msc_sup_dem_entries sd2
2282: where sd2.plan_id = sd1.plan_id
2283: and sd2.sr_instance_id = sd1.sr_instance_id
2284: and sd2.publisher_order_type = 3
2285: and sd2.customer_id = sd1.publisher_id

Line 2302: from msc_sup_dem_entries sd1

2298: sd1.supplier_site_id,
2299: nvl(sd1.base_item_id,sd1.inventory_item_id) item_id,
2300: sd1.last_refresh_number,
2301: sd1.key_date
2302: from msc_sup_dem_entries sd1
2303: where sd1.publisher_order_type = 2
2304: and sd1.plan_id= -1
2305: and sd1.last_refresh_number > p_refresh_number
2306: and exists (select 1

Line 2307: from msc_sup_dem_entries sd2

2303: where sd1.publisher_order_type = 2
2304: and sd1.plan_id= -1
2305: and sd1.last_refresh_number > p_refresh_number
2306: and exists (select 1
2307: from msc_sup_dem_entries sd2
2308: where sd2.plan_id = sd1.plan_id
2309: and sd2.sr_instance_id = sd1.sr_instance_id
2310: and sd2.publisher_order_type = 14
2311: and sd2.customer_id = sd1.publisher_id

Line 2337: from msc_sup_dem_entries sd1

2333: sd1.publisher_site_id supplier_site_id,
2334: nvl(sd1.base_item_id,sd1.inventory_item_id) item_id,
2335: sd1.last_refresh_number,
2336: sd1.key_date
2337: from msc_sup_dem_entries sd1
2338: where sd1.publisher_order_type = 3
2339: and sd1.plan_id= -1
2340: and sd1.last_refresh_number > p_refresh_number
2341: and exists (select 1

Line 2342: from msc_sup_dem_entries sd2

2338: where sd1.publisher_order_type = 3
2339: and sd1.plan_id= -1
2340: and sd1.last_refresh_number > p_refresh_number
2341: and exists (select 1
2342: from msc_sup_dem_entries sd2
2343: where sd2.plan_id = sd1.plan_id
2344: and sd2.sr_instance_id = sd1.sr_instance_id
2345: and sd2.publisher_order_type = 2
2346: and sd2.publisher_id = sd1.customer_id

Line 2362: from msc_sup_dem_entries sd1

2358: sd1.publisher_site_id supplier_site_id,
2359: nvl(sd1.base_item_id,sd1.inventory_item_id) item_id,
2360: sd1.last_refresh_number,
2361: sd1.key_date
2362: from msc_sup_dem_entries sd1
2363: where sd1.publisher_order_type = 14
2364: and sd1.plan_id= -1
2365: and sd1.last_refresh_number > p_refresh_number
2366: and exists (select 1

Line 2367: from msc_sup_dem_entries sd2

2363: where sd1.publisher_order_type = 14
2364: and sd1.plan_id= -1
2365: and sd1.last_refresh_number > p_refresh_number
2366: and exists (select 1
2367: from msc_sup_dem_entries sd2
2368: where sd2.plan_id = sd1.plan_id
2369: and sd2.sr_instance_id = sd1.sr_instance_id
2370: and sd2.publisher_order_type = 2
2371: and sd2.publisher_id = sd1.customer_id

Line 2398: from msc_sup_dem_entries;

2394: commit;
2395:
2396: select nvl(max(last_refresh_number),0)
2397: into lv_cutoff_ref_num
2398: from msc_sup_dem_entries;
2399:
2400:
2401: /* These cursors c2 and c3 are not used at all .
2402: These were alternatives tried for performance gains */