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

Line 1203: -- SPP calculate Return Forecast, DOS and push it to msc_sup_dem_entries only when SPP plan is run

1199: p_project_id,
1200: p_task_id ,
1201: ORDER_FORECAST);
1202:
1203: -- SPP calculate Return Forecast, DOS and push it to msc_sup_dem_entries only when SPP plan is run
1204: IF l_plan_type = SPP_PLAN THEN
1205: OPEN defective_planned_orders_c1 (
1206: p_plan_id
1207: ,p_org_id

Line 1386: FROM msc_sup_dem_entries

1382: BEGIN
1383: SELECT 1 INTO l_records_exist
1384: FROM dual
1385: WHERE exists ( SELECT 1
1386: FROM msc_sup_dem_entries
1387: WHERE plan_id = -1
1388: AND publisher_order_type = 2
1389: AND designator = p_designator
1390: AND version = TO_CHAR(l_version));

Line 1807: l_base_item_name msc_sup_dem_entries.item_name%type;

1803: l_tp_planned_order_qty Number;
1804: l_released_qty Number;
1805: l_tp_released_qty Number;
1806: l_item_id Number;
1807: l_base_item_name msc_sup_dem_entries.item_name%type;
1808: l_base_item_desc msc_sup_dem_entries.item_description%type;
1809:
1810: BEGIN
1811:

Line 1808: l_base_item_desc msc_sup_dem_entries.item_description%type;

1804: l_released_qty Number;
1805: l_tp_released_qty Number;
1806: l_item_id Number;
1807: l_base_item_name msc_sup_dem_entries.item_name%type;
1808: l_base_item_desc msc_sup_dem_entries.item_description%type;
1809:
1810: BEGIN
1811:
1812:

Line 1842: update msc_sup_dem_entries

1838: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
1839: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
1840: begin
1841: IF (t_base_item_id(j) is not null) THEN
1842: update msc_sup_dem_entries
1843: set quantity = quantity + t_qty(j),
1844: primary_quantity = primary_quantity + t_qty(j),
1845: tp_quantity = tp_quantity + t_tp_qty(j)
1846: where publisher_id = t_pub_id(j)

Line 1854: insert into msc_sup_dem_entries (

1850: and inventory_item_id = t_base_item_id(j)
1851: and trunc(key_date) = trunc(t_key_date(j))
1852: and publisher_order_type = ORDER_FORECAST;
1853: IF (SQL%ROWCOUNT = 0) THEN
1854: insert into msc_sup_dem_entries (
1855: transaction_id,
1856: plan_id,
1857: sr_instance_id,
1858: publisher_name,

Line 1914: msc_sup_dem_entries_s.nextval,

1910: planner_code,
1911: version,
1912: designator
1913: ) values (
1914: msc_sup_dem_entries_s.nextval,
1915: -1,
1916: -1,
1917: t_pub(j),
1918: t_pub_id(j),

Line 1974: update msc_sup_dem_entries

1970: p_version,
1971: p_designator);
1972: END IF; --rowcount
1973: ELSE
1974: update msc_sup_dem_entries
1975: set quantity = quantity + t_qty(j),
1976: primary_quantity = primary_quantity + t_qty(j),
1977: tp_quantity = tp_quantity + t_tp_qty(j)
1978: where publisher_id = t_pub_id(j)

Line 1996: update msc_sup_dem_entries

1992: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
1993: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
1994: begin
1995: IF (t_base_item_id(j) is not null) THEN
1996: update msc_sup_dem_entries
1997: set quantity = quantity + t_qty(j),
1998: primary_quantity = primary_quantity + t_qty(j),
1999: tp_quantity = tp_quantity + t_tp_qty(j)
2000: where publisher_id = t_pub_id(j)

Line 2008: insert into msc_sup_dem_entries (

2004: and inventory_item_id = t_base_item_id(j)
2005: and trunc(key_date) = trunc(t_key_date(j))
2006: and publisher_order_type = ORDER_FORECAST;
2007: IF (SQL%ROWCOUNT = 0) THEN
2008: insert into msc_sup_dem_entries (
2009: transaction_id,
2010: plan_id,
2011: sr_instance_id,
2012: publisher_name,

Line 2068: msc_sup_dem_entries_s.nextval,

2064: planner_code,
2065: version,
2066: designator
2067: ) values (
2068: msc_sup_dem_entries_s.nextval,
2069: -1,
2070: -1,
2071: t_pub(j),
2072: t_pub_id(j),

Line 2128: update msc_sup_dem_entries

2124: p_version,
2125: p_designator);
2126: END IF; --rowcount
2127: ELSE
2128: update msc_sup_dem_entries
2129: set quantity = quantity + t_qty(j),
2130: primary_quantity = primary_quantity + t_qty(j),
2131: tp_quantity = tp_quantity + t_tp_qty(j)
2132: where publisher_id = t_pub_id(j)

Line 2150: update msc_sup_dem_entries

2146: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
2147: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2148: begin
2149: IF (t_base_item_id(j) is not null) THEN
2150: update msc_sup_dem_entries
2151: set quantity = quantity + t_qty(j),
2152: primary_quantity = primary_quantity + t_qty(j),
2153: tp_quantity = tp_quantity + t_tp_qty(j)
2154: where publisher_id = t_pub_id(j)

Line 2162: insert into msc_sup_dem_entries (

2158: and inventory_item_id = t_base_item_id(j)
2159: and trunc(key_date) = trunc(t_key_date(j))
2160: and publisher_order_type = ORDER_FORECAST;
2161: IF (SQL%ROWCOUNT = 0) THEN
2162: insert into msc_sup_dem_entries (
2163: transaction_id,
2164: plan_id,
2165: sr_instance_id,
2166: publisher_name,

Line 2222: msc_sup_dem_entries_s.nextval,

2218: planner_code,
2219: version,
2220: designator
2221: ) values (
2222: msc_sup_dem_entries_s.nextval,
2223: -1,
2224: -1,
2225: t_pub(j),
2226: t_pub_id(j),

Line 2282: update msc_sup_dem_entries

2278: p_version,
2279: p_designator);
2280: END IF; --rowcount
2281: ELSE
2282: update msc_sup_dem_entries
2283: set quantity = quantity + t_qty(j),
2284: primary_quantity = primary_quantity + t_qty(j),
2285: tp_quantity = tp_quantity + t_tp_qty(j)
2286: where publisher_id = t_pub_id(j)

Line 2304: update msc_sup_dem_entries

2300: begin
2301: IF (t_base_item_id(j) is not null) THEN
2302:
2303:
2304: update msc_sup_dem_entries
2305: set quantity = quantity + t_qty(j),
2306: primary_quantity = primary_quantity + t_qty(j),
2307: tp_quantity = tp_quantity + t_tp_qty(j)
2308: where publisher_id = t_pub_id(j)

Line 2317: insert into msc_sup_dem_entries (

2313: and trunc(key_date) = trunc(t_key_date(j))
2314: and publisher_order_type = ORDER_FORECAST;
2315:
2316: IF (SQL%ROWCOUNT = 0) THEN
2317: insert into msc_sup_dem_entries (
2318: transaction_id,
2319: plan_id,
2320: sr_instance_id,
2321: publisher_name,

Line 2377: msc_sup_dem_entries_s.nextval,

2373: planner_code,
2374: version,
2375: designator
2376: ) values (
2377: msc_sup_dem_entries_s.nextval,
2378: -1,
2379: -1,
2380: t_pub(j),
2381: t_pub_id(j),

Line 2437: update msc_sup_dem_entries

2433: p_version,
2434: p_designator);
2435: END IF; --rowcount
2436: ELSE
2437: update msc_sup_dem_entries
2438: set quantity = quantity + t_qty(j),
2439: primary_quantity = primary_quantity + t_qty(j),
2440: tp_quantity = quantity + t_tp_qty(j)
2441: where publisher_id = t_pub_id(j)

Line 2451: update msc_sup_dem_entries

2447: and publisher_order_type = ORDER_FORECAST;
2448:
2449: END IF;
2450:
2451: update msc_sup_dem_entries
2452: set quantity = quantity + t_planned_order_qty(j),
2453: primary_quantity = primary_quantity + t_planned_order_qty(j) ,
2454: tp_quantity = tp_quantity + t_tp_planned_order_qty(j)
2455: where publisher_id = t_pub_id(j)

Line 2463: update msc_sup_dem_entries

2459: and inventory_item_id = t_item_id(j)
2460: and trunc(key_date) = trunc(t_key_date(j))
2461: and publisher_order_type = CP_PLANNED_ORDER;
2462:
2463: update msc_sup_dem_entries
2464: set quantity = quantity + t_released_qty(j),
2465: primary_quantity = primary_quantity + t_released_qty(j),
2466: tp_quantity = tp_quantity + t_tp_released_qty(j)
2467: where publisher_id = t_pub_id(j)

Line 2483: update msc_sup_dem_entries

2479: ELSIF (t_order_type(j) = REQUISITION) THEN
2480:
2481: IF (t_base_item_id(j) is not null) THEN
2482:
2483: update msc_sup_dem_entries
2484: set quantity = quantity + t_qty(j),
2485: primary_quantity = primary_quantity + t_qty(j),
2486: tp_quantity = tp_quantity + t_tp_qty(j)
2487: where publisher_id = t_pub_id(j)

Line 2495: insert into msc_sup_dem_entries (

2491: and inventory_item_id = t_base_item_id(j)
2492: and trunc(key_date) = trunc(t_key_date(j))
2493: and publisher_order_type = ORDER_FORECAST;
2494: IF (SQL%ROWCOUNT = 0) THEN
2495: insert into msc_sup_dem_entries (
2496: transaction_id,
2497: plan_id,
2498: sr_instance_id,
2499: publisher_name,

Line 2555: msc_sup_dem_entries_s.nextval,

2551: planner_code,
2552: version,
2553: designator
2554: ) values (
2555: msc_sup_dem_entries_s.nextval,
2556: -1,
2557: -1,
2558: t_pub(j),
2559: t_pub_id(j),

Line 2616: update msc_sup_dem_entries

2612: p_designator);
2613: END IF; --rowcount
2614:
2615: ELSE
2616: update msc_sup_dem_entries
2617: set quantity = quantity + t_qty(j),
2618: primary_quantity = primary_quantity + t_qty(j),
2619: tp_quantity = tp_quantity + t_tp_qty(j)
2620: where publisher_id = t_pub_id(j)

Line 2633: update msc_sup_dem_entries

2629: ELSIF (t_order_type(j) = PURCHASE_ORDER) THEN
2630:
2631:
2632: IF (t_base_item_id(j) is not null) THEN
2633: update msc_sup_dem_entries
2634: set quantity = quantity + t_qty(j),
2635: primary_quantity = primary_quantity + t_qty(j),
2636: tp_quantity = tp_quantity + t_tp_qty(j)
2637: where publisher_id = t_pub_id(j)

Line 2645: update msc_sup_dem_entries

2641: and inventory_item_id = t_base_item_id(j)
2642: and trunc(key_date) = trunc(t_key_date(j))
2643: and publisher_order_type = ORDER_FORECAST;
2644: ELSE
2645: update msc_sup_dem_entries
2646: set quantity = quantity + t_qty(j),
2647: primary_quantity = primary_quantity + t_qty(j),
2648: tp_quantity = tp_quantity + t_tp_qty(j)
2649: where publisher_id = t_pub_id(j)

Line 2657: update msc_sup_dem_entries

2653: and inventory_item_id = t_item_id(j)
2654: and trunc(key_date) = trunc(t_key_date(j))
2655: and publisher_order_type = ORDER_FORECAST;
2656: END IF;
2657: update msc_sup_dem_entries
2658: set quantity = quantity + t_qty(j),
2659: primary_quantity = primary_quantity + t_qty(j) ,
2660: tp_quantity = tp_quantity + t_tp_qty(j)
2661: where publisher_id = t_pub_id(j)

Line 2676: update msc_sup_dem_entries

2672: begin
2673: IF (t_base_item_id(j) is not null) THEN
2674:
2675:
2676: update msc_sup_dem_entries
2677: set quantity = quantity + t_qty(j),
2678: primary_quantity = primary_quantity + t_qty(j),
2679: tp_quantity = tp_quantity + t_tp_qty(j)
2680: where publisher_id = t_pub_id(j)

Line 2689: insert into msc_sup_dem_entries (

2685: and trunc(key_date) = trunc(t_key_date(j))
2686: and publisher_order_type = ORDER_FORECAST;
2687:
2688: IF (SQL%ROWCOUNT = 0) THEN
2689: insert into msc_sup_dem_entries (
2690: transaction_id,
2691: plan_id,
2692: sr_instance_id,
2693: publisher_name,

Line 2749: msc_sup_dem_entries_s.nextval,

2745: planner_code,
2746: version,
2747: designator
2748: ) values (
2749: msc_sup_dem_entries_s.nextval,
2750: -1,
2751: -1,
2752: t_pub(j),
2753: t_pub_id(j),

Line 2809: update msc_sup_dem_entries

2805: p_version,
2806: p_designator);
2807: END IF; --rowcount
2808: ELSE
2809: update msc_sup_dem_entries
2810: set quantity = quantity + t_qty(j),
2811: primary_quantity = primary_quantity + t_qty(j),
2812: tp_quantity = quantity + t_tp_qty(j)
2813: where publisher_id = t_pub_id(j)

Line 2823: update msc_sup_dem_entries

2819: and publisher_order_type = ORDER_FORECAST;
2820:
2821: END IF;
2822:
2823: update msc_sup_dem_entries
2824: set quantity = quantity + t_planned_order_qty(j),
2825: primary_quantity = primary_quantity + t_planned_order_qty(j) ,
2826: tp_quantity = tp_quantity + t_tp_planned_order_qty(j)
2827: where publisher_id = t_pub_id(j)

Line 2835: update msc_sup_dem_entries

2831: and inventory_item_id = t_item_id(j)
2832: and trunc(key_date) = trunc(t_key_date(j))
2833: and publisher_order_type = CP_PLANNED_INBOUND_SHIPMENT;
2834:
2835: update msc_sup_dem_entries
2836: set quantity = quantity + t_released_qty(j),
2837: primary_quantity = primary_quantity + t_released_qty(j),
2838: tp_quantity = tp_quantity + t_tp_released_qty(j)
2839: where publisher_id = t_pub_id(j)

Line 2867: update msc_sup_dem_entries

2863: trunc(t_ship_date(j)) = trunc(t_ship_date(j-1)) and
2864: t_order_type(j) <> t_order_type(j-1)) THEN
2865:
2866: IF (t_base_item_id(j) is not null) THEN
2867: update msc_sup_dem_entries
2868: set quantity = quantity + t_qty(j),
2869: primary_quantity = primary_quantity + t_qty(j) ,
2870: tp_quantity = tp_quantity + t_tp_qty(j)
2871: where publisher_id = t_pub_id(j)

Line 2879: insert into msc_sup_dem_entries (

2875: and inventory_item_id = t_base_item_id(j)
2876: and trunc(key_date) = trunc(t_key_date(j))
2877: and publisher_order_type = ORDER_FORECAST;
2878: IF (SQL%ROWCOUNT = 0) THEN
2879: insert into msc_sup_dem_entries (
2880: transaction_id,
2881: plan_id,
2882: sr_instance_id,
2883: publisher_name,

Line 2939: msc_sup_dem_entries_s.nextval,

2935: planner_code,
2936: version,
2937: designator
2938: ) values (
2939: msc_sup_dem_entries_s.nextval,
2940: -1,
2941: -1,
2942: t_pub(j),
2943: t_pub_id(j),

Line 3000: update msc_sup_dem_entries

2996: p_designator);
2997: END IF; --rowcount
2998:
2999: ELSE
3000: update msc_sup_dem_entries
3001: set quantity = quantity + t_qty(j),
3002: primary_quantity = primary_quantity + t_qty(j) ,
3003: tp_quantity = tp_quantity + t_tp_qty(j)
3004: where publisher_id = t_pub_id(j)

Line 3030: insert into msc_sup_dem_entries (

3026: IF (t_planned_order_qty(j) < 0 ) THEN
3027: l_planned_order_qty := 0;
3028: l_tp_planned_order_qty := 0;
3029: END IF;
3030: insert into msc_sup_dem_entries (
3031: transaction_id,
3032: plan_id,
3033: sr_instance_id,
3034: publisher_name,

Line 3092: msc_sup_dem_entries_s.nextval,

3088: designator,
3089: base_item_id,
3090: base_item_name
3091: ) values (
3092: msc_sup_dem_entries_s.nextval,
3093: -1,
3094: -1,
3095: t_pub(j),
3096: t_pub_id(j),

Line 3169: insert into msc_sup_dem_entries (

3165: END IF;
3166: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '
3167: -- || t_tp_released_qty(j) || 'date ' || t_key_date(j));
3168: log_message( 'released qty ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
3169: insert into msc_sup_dem_entries (
3170: transaction_id,
3171: plan_id,
3172: sr_instance_id,
3173: publisher_name,

Line 3231: msc_sup_dem_entries_s.nextval,

3227: designator,
3228: base_item_id,
3229: base_item_name
3230: ) values (
3231: msc_sup_dem_entries_s.nextval,
3232: -1,
3233: -1,
3234: t_pub(j),
3235: t_pub_id(j),

Line 3304: insert into msc_sup_dem_entries (

3300:
3301: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
3302: --|| 'date ' || t_key_date(j));
3303: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));
3304: insert into msc_sup_dem_entries (
3305: transaction_id,
3306: plan_id,
3307: sr_instance_id,
3308: publisher_name,

Line 3366: msc_sup_dem_entries_s.nextval,

3362: designator,
3363: base_item_id,
3364: base_item_name
3365: ) values (
3366: msc_sup_dem_entries_s.nextval,
3367: -1,
3368: -1,
3369: t_pub(j),
3370: t_pub_id(j),

Line 3446: insert into msc_sup_dem_entries (

3442: l_tp_planned_order_qty := 0;
3443: END IF;
3444: log_message(' PIS ' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || ' date ' || t_key_date(j));
3445:
3446: insert into msc_sup_dem_entries (
3447: transaction_id,
3448: plan_id,
3449: sr_instance_id,
3450: publisher_name,

Line 3508: msc_sup_dem_entries_s.nextval,

3504: designator,
3505: base_item_id,
3506: base_item_name
3507: ) values (
3508: msc_sup_dem_entries_s.nextval,
3509: -1,
3510: -1,
3511: t_pub(j),
3512: t_pub_id(j),

Line 3584: insert into msc_sup_dem_entries (

3580: l_tp_released_qty := 0;
3581: END IF;
3582:
3583: log_message( 'released qty from PIS ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || ' date ' || t_key_date(j));
3584: insert into msc_sup_dem_entries (
3585: transaction_id,
3586: plan_id,
3587: sr_instance_id,
3588: publisher_name,

Line 3646: msc_sup_dem_entries_s.nextval,

3642: designator,
3643: base_item_id,
3644: base_item_name
3645: ) values (
3646: msc_sup_dem_entries_s.nextval,
3647: -1,
3648: -1,
3649: t_pub(j),
3650: t_pub_id(j),

Line 3733: FROM msc_sup_dem_entries

3729: l_count := 0;
3730:
3731: SELECT count(*)
3732: INTO l_count
3733: FROM msc_sup_dem_entries
3734: where publisher_id = t_pub_id(j)
3735: and publisher_site_id = t_pub_site_id(j)
3736: and supplier_id = t_supp_id(j)
3737: and supplier_site_id = t_supp_site_id(j)

Line 3744: update msc_sup_dem_entries

3740: and publisher_order_type = ORDER_FORECAST;
3741:
3742: IF l_count > 0 THEN
3743:
3744: update msc_sup_dem_entries
3745: set quantity = quantity + t_qty(j),
3746: primary_quantity = primary_quantity + t_qty(j) ,
3747: tp_quantity = tp_quantity + t_tp_qty(j)
3748: where publisher_id = t_pub_id(j)

Line 3758: insert into msc_sup_dem_entries (

3754: and publisher_order_type = ORDER_FORECAST;
3755: ELSE
3756:
3757: begin
3758: insert into msc_sup_dem_entries (
3759: transaction_id,
3760: plan_id,
3761: sr_instance_id,
3762: publisher_name,

Line 3818: msc_sup_dem_entries_s.nextval,

3814: planner_code,
3815: version,
3816: designator
3817: ) values (
3818: msc_sup_dem_entries_s.nextval,
3819: -1,
3820: -1,
3821: t_pub(j),
3822: t_pub_id(j),

Line 3903: insert into msc_sup_dem_entries (

3899: IF (t_planned_order_qty(j) < 0 ) THEN
3900: l_planned_order_qty := 0;
3901: l_tp_planned_order_qty := 0;
3902: END IF;
3903: insert into msc_sup_dem_entries (
3904: transaction_id,
3905: plan_id,
3906: sr_instance_id,
3907: publisher_name,

Line 3965: msc_sup_dem_entries_s.nextval,

3961: designator,
3962: base_item_id,
3963: base_item_name
3964: ) values (
3965: msc_sup_dem_entries_s.nextval,
3966: -1,
3967: -1,
3968: t_pub(j),
3969: t_pub_id(j),

Line 4042: insert into msc_sup_dem_entries (

4038: END IF;
4039: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '
4040: -- || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4041: log_message( 'released qty ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4042: insert into msc_sup_dem_entries (
4043: transaction_id,
4044: plan_id,
4045: sr_instance_id,
4046: publisher_name,

Line 4104: msc_sup_dem_entries_s.nextval,

4100: designator,
4101: base_item_id,
4102: base_item_name
4103: ) values (
4104: msc_sup_dem_entries_s.nextval,
4105: -1,
4106: -1,
4107: t_pub(j),
4108: t_pub_id(j),

Line 4176: insert into msc_sup_dem_entries (

4172: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4173: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
4174: --|| 'date ' || t_key_date(j));
4175: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));
4176: insert into msc_sup_dem_entries (
4177: transaction_id,
4178: plan_id,
4179: sr_instance_id,
4180: publisher_name,

Line 4238: msc_sup_dem_entries_s.nextval,

4234: designator,
4235: base_item_id,
4236: base_item_name
4237: ) values (
4238: msc_sup_dem_entries_s.nextval,
4239: -1,
4240: -1,
4241: t_pub(j),
4242: t_pub_id(j),

Line 4319: insert into msc_sup_dem_entries (

4315: l_tp_planned_order_qty := 0;
4316: END IF;
4317: log_message('PIS ' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || ' date ' || t_key_date(j));
4318:
4319: insert into msc_sup_dem_entries (
4320: transaction_id,
4321: plan_id,
4322: sr_instance_id,
4323: publisher_name,

Line 4381: msc_sup_dem_entries_s.nextval,

4377: designator,
4378: base_item_id,
4379: base_item_name
4380: ) values (
4381: msc_sup_dem_entries_s.nextval,
4382: -1,
4383: -1,
4384: t_pub(j),
4385: t_pub_id(j),

Line 4457: insert into msc_sup_dem_entries (

4453: l_tp_released_qty := 0;
4454: END IF;
4455: log_message( 'released qty from PIS ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4456:
4457: insert into msc_sup_dem_entries (
4458: transaction_id,
4459: plan_id,
4460: sr_instance_id,
4461: publisher_name,

Line 4519: msc_sup_dem_entries_s.nextval,

4515: designator,
4516: base_item_id,
4517: base_item_name
4518: ) values (
4519: msc_sup_dem_entries_s.nextval,
4520: -1,
4521: -1,
4522: t_pub(j),
4523: t_pub_id(j),

Line 4589: update msc_sup_dem_entries

4585: END LOOP;
4586:
4587: -- break into 2 queries for performance purpose
4588: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4589: update msc_sup_dem_entries
4590: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4591: where publisher_order_type = CP_PLANNED_ORDER
4592: and publisher_id = t_pub_id(j)
4593: and publisher_site_id = t_pub_site_id(j)

Line 4601: update msc_sup_dem_entries

4597: and quantity < 0;
4598:
4599:
4600: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4601: update msc_sup_dem_entries
4602: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4603: where publisher_order_type = CP_RELEASED_PLANNED_ORDER
4604: and publisher_id = t_pub_id(j)
4605: and publisher_site_id = t_pub_site_id(j)

Line 4614: update msc_sup_dem_entries

4610:
4611: -- added for PIS
4612:
4613: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4614: update msc_sup_dem_entries
4615: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4616: where publisher_order_type = CP_PLANNED_INBOUND_SHIPMENT
4617: and publisher_id = t_pub_id(j)
4618: and publisher_site_id = t_pub_site_id(j)

Line 4626: update msc_sup_dem_entries

4622: and quantity < 0;
4623:
4624:
4625: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4626: update msc_sup_dem_entries
4627: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4628: where publisher_order_type = CP_RELEASED_INBOUND_SHIPMENT
4629: and publisher_id = t_pub_id(j)
4630: and publisher_site_id = t_pub_site_id(j)

Line 4731: update msc_sup_dem_entries

4727: l_qty := 0;
4728: l_tp_qty := 0;
4729: END IF;
4730: --=============
4731: update msc_sup_dem_entries
4732: set quantity = quantity + l_qty,
4733: primary_quantity = primary_quantity + l_qty,
4734: tp_quantity = tp_quantity + l_tp_qty
4735: where publisher_id = t_pub_id(j)

Line 4746: INSERT INTO msc_sup_dem_entries

4742:
4743: IF SQL%NOTFOUND THEN
4744: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',RETURNS_FORECAST);
4745: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4746: INSERT INTO msc_sup_dem_entries
4747: (transaction_id,
4748: plan_id,
4749: sr_instance_id,
4750: publisher_name,

Line 4808: msc_sup_dem_entries_s.nextval,

4804: designator,
4805: base_item_id,
4806: base_item_name)
4807: VALUES(
4808: msc_sup_dem_entries_s.nextval,
4809: -1,
4810: -1,
4811: t_pub(j),
4812: t_pub_id(j),

Line 4874: update msc_sup_dem_entries

4870:
4871: -- Publish DOS Start (only when Publish Defective Outbound Shipment = YES in MSCXPO)
4872: IF (p_publish_dos = 1 AND ( t_order_type(j) IN (ISO_DEF, INTRANSIT_SHIPMENT_DEF, INTRANSIT_RECEIPT_DEF))) THEN
4873:
4874: update msc_sup_dem_entries
4875: set quantity = quantity + l_qty,
4876: primary_quantity = primary_quantity + l_qty,
4877: tp_quantity = tp_quantity + l_tp_qty
4878: where publisher_id = t_pub_id(j)

Line 4891: INSERT INTO msc_sup_dem_entries

4887:
4888: IF SQL%NOTFOUND THEN
4889: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',DEFECTIVE_OUTBOUND_SHIPMENT);
4890: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4891: INSERT INTO msc_sup_dem_entries
4892: (transaction_id,
4893: plan_id,
4894: sr_instance_id,
4895: publisher_name,

Line 4955: msc_sup_dem_entries_s.nextval,

4951: designator,
4952: base_item_id,
4953: base_item_name)
4954: VALUES(
4955: msc_sup_dem_entries_s.nextval,
4956: -1,
4957: -1,
4958: t_pub(j),
4959: t_pub_id(j),

Line 5102: delete from msc_sup_dem_entries sd

5098:
5099: log_message('l_supplier_site_id := ' || l_supplier_site_id);
5100:
5101: IF ( p_overwrite = 1) THEN --delete all
5102: delete from msc_sup_dem_entries sd
5103: where sd.publisher_order_type in (ORDER_FORECAST,CP_PLANNED_ORDER,
5104: CP_PURCHASE_ORDER_FROM_PLAN,CP_RELEASED_PLANNED_ORDER,
5105: CP_PLANNED_INBOUND_SHIPMENT, CP_RELEASED_INBOUND_SHIPMENT,
5106: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383

Line 5148: delete from msc_sup_dem_entries sd

5144: l_row := SQL%ROWCOUNT;
5145: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
5146:
5147: ELSIF ( p_overwrite = 2) THEN --delete by overwritten
5148: delete from msc_sup_dem_entries sd
5149: where sd.publisher_order_type IN (ORDER_FORECAST, CP_PLANNED_ORDER,
5150: CP_PURCHASE_ORDER_FROM_PLAN, CP_RELEASED_PLANNED_ORDER,
5151: CP_PLANNED_INBOUND_SHIPMENT, CP_RELEASED_INBOUND_SHIPMENT,
5152: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383