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 1220: -- SPP calculate Return Forecast, DOS and push it to msc_sup_dem_entries only when SPP plan is run

1216: p_project_id,
1217: p_task_id ,
1218: ORDER_FORECAST);
1219:
1220: -- SPP calculate Return Forecast, DOS and push it to msc_sup_dem_entries only when SPP plan is run
1221: IF l_plan_type = SPP_PLAN THEN
1222: OPEN defective_planned_orders_c1 (
1223: p_plan_id
1224: ,p_org_id

Line 1403: FROM msc_sup_dem_entries

1399: BEGIN
1400: SELECT 1 INTO l_records_exist
1401: FROM dual
1402: WHERE exists ( SELECT 1
1403: FROM msc_sup_dem_entries
1404: WHERE plan_id = -1
1405: AND publisher_order_type = 2
1406: AND designator = p_designator
1407: AND version = TO_CHAR(l_version));

Line 1824: l_base_item_name msc_sup_dem_entries.item_name%type;

1820: l_tp_planned_order_qty Number;
1821: l_released_qty Number;
1822: l_tp_released_qty Number;
1823: l_item_id Number;
1824: l_base_item_name msc_sup_dem_entries.item_name%type;
1825: l_base_item_desc msc_sup_dem_entries.item_description%type;
1826:
1827: BEGIN
1828:

Line 1825: l_base_item_desc msc_sup_dem_entries.item_description%type;

1821: l_released_qty Number;
1822: l_tp_released_qty Number;
1823: l_item_id Number;
1824: l_base_item_name msc_sup_dem_entries.item_name%type;
1825: l_base_item_desc msc_sup_dem_entries.item_description%type;
1826:
1827: BEGIN
1828:
1829:

Line 1859: update msc_sup_dem_entries

1855: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
1856: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
1857: begin
1858: IF (t_base_item_id(j) is not null) THEN
1859: update msc_sup_dem_entries
1860: set quantity = quantity + t_qty(j),
1861: primary_quantity = primary_quantity + t_qty(j),
1862: tp_quantity = tp_quantity + t_tp_qty(j)
1863: where publisher_id = t_pub_id(j)

Line 1871: insert into msc_sup_dem_entries (

1867: and inventory_item_id = t_base_item_id(j)
1868: and trunc(key_date) = trunc(t_key_date(j))
1869: and publisher_order_type = ORDER_FORECAST;
1870: IF (SQL%ROWCOUNT = 0) THEN
1871: insert into msc_sup_dem_entries (
1872: transaction_id,
1873: plan_id,
1874: sr_instance_id,
1875: publisher_name,

Line 1931: msc_sup_dem_entries_s.nextval,

1927: planner_code,
1928: version,
1929: designator
1930: ) values (
1931: msc_sup_dem_entries_s.nextval,
1932: -1,
1933: -1,
1934: t_pub(j),
1935: t_pub_id(j),

Line 1991: update msc_sup_dem_entries

1987: p_version,
1988: p_designator);
1989: END IF; --rowcount
1990: ELSE
1991: update msc_sup_dem_entries
1992: set quantity = quantity + t_qty(j),
1993: primary_quantity = primary_quantity + t_qty(j),
1994: tp_quantity = tp_quantity + t_tp_qty(j)
1995: where publisher_id = t_pub_id(j)

Line 2013: update msc_sup_dem_entries

2009: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
2010: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2011: begin
2012: IF (t_base_item_id(j) is not null) THEN
2013: update msc_sup_dem_entries
2014: set quantity = quantity + t_qty(j),
2015: primary_quantity = primary_quantity + t_qty(j),
2016: tp_quantity = tp_quantity + t_tp_qty(j)
2017: where publisher_id = t_pub_id(j)

Line 2025: insert into msc_sup_dem_entries (

2021: and inventory_item_id = t_base_item_id(j)
2022: and trunc(key_date) = trunc(t_key_date(j))
2023: and publisher_order_type = ORDER_FORECAST;
2024: IF (SQL%ROWCOUNT = 0) THEN
2025: insert into msc_sup_dem_entries (
2026: transaction_id,
2027: plan_id,
2028: sr_instance_id,
2029: publisher_name,

Line 2085: msc_sup_dem_entries_s.nextval,

2081: planner_code,
2082: version,
2083: designator
2084: ) values (
2085: msc_sup_dem_entries_s.nextval,
2086: -1,
2087: -1,
2088: t_pub(j),
2089: t_pub_id(j),

Line 2145: update msc_sup_dem_entries

2141: p_version,
2142: p_designator);
2143: END IF; --rowcount
2144: ELSE
2145: update msc_sup_dem_entries
2146: set quantity = quantity + t_qty(j),
2147: primary_quantity = primary_quantity + t_qty(j),
2148: tp_quantity = tp_quantity + t_tp_qty(j)
2149: where publisher_id = t_pub_id(j)

Line 2167: update msc_sup_dem_entries

2163: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
2164: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
2165: begin
2166: IF (t_base_item_id(j) is not null) THEN
2167: update msc_sup_dem_entries
2168: set quantity = quantity + t_qty(j),
2169: primary_quantity = primary_quantity + t_qty(j),
2170: tp_quantity = tp_quantity + t_tp_qty(j)
2171: where publisher_id = t_pub_id(j)

Line 2179: insert into msc_sup_dem_entries (

2175: and inventory_item_id = t_base_item_id(j)
2176: and trunc(key_date) = trunc(t_key_date(j))
2177: and publisher_order_type = ORDER_FORECAST;
2178: IF (SQL%ROWCOUNT = 0) THEN
2179: insert into msc_sup_dem_entries (
2180: transaction_id,
2181: plan_id,
2182: sr_instance_id,
2183: publisher_name,

Line 2239: msc_sup_dem_entries_s.nextval,

2235: planner_code,
2236: version,
2237: designator
2238: ) values (
2239: msc_sup_dem_entries_s.nextval,
2240: -1,
2241: -1,
2242: t_pub(j),
2243: t_pub_id(j),

Line 2299: update msc_sup_dem_entries

2295: p_version,
2296: p_designator);
2297: END IF; --rowcount
2298: ELSE
2299: update msc_sup_dem_entries
2300: set quantity = quantity + t_qty(j),
2301: primary_quantity = primary_quantity + t_qty(j),
2302: tp_quantity = tp_quantity + t_tp_qty(j)
2303: where publisher_id = t_pub_id(j)

Line 2321: update msc_sup_dem_entries

2317: begin
2318: IF (t_base_item_id(j) is not null) THEN
2319:
2320:
2321: update msc_sup_dem_entries
2322: set quantity = quantity + t_qty(j),
2323: primary_quantity = primary_quantity + t_qty(j),
2324: tp_quantity = tp_quantity + t_tp_qty(j)
2325: where publisher_id = t_pub_id(j)

Line 2334: insert into msc_sup_dem_entries (

2330: and trunc(key_date) = trunc(t_key_date(j))
2331: and publisher_order_type = ORDER_FORECAST;
2332:
2333: IF (SQL%ROWCOUNT = 0) THEN
2334: insert into msc_sup_dem_entries (
2335: transaction_id,
2336: plan_id,
2337: sr_instance_id,
2338: publisher_name,

Line 2394: msc_sup_dem_entries_s.nextval,

2390: planner_code,
2391: version,
2392: designator
2393: ) values (
2394: msc_sup_dem_entries_s.nextval,
2395: -1,
2396: -1,
2397: t_pub(j),
2398: t_pub_id(j),

Line 2454: update msc_sup_dem_entries

2450: p_version,
2451: p_designator);
2452: END IF; --rowcount
2453: ELSE
2454: update msc_sup_dem_entries
2455: set quantity = quantity + t_qty(j),
2456: primary_quantity = primary_quantity + t_qty(j),
2457: tp_quantity = quantity + t_tp_qty(j)
2458: where publisher_id = t_pub_id(j)

Line 2468: update msc_sup_dem_entries

2464: and publisher_order_type = ORDER_FORECAST;
2465:
2466: END IF;
2467:
2468: update msc_sup_dem_entries
2469: set quantity = quantity + t_planned_order_qty(j),
2470: primary_quantity = primary_quantity + t_planned_order_qty(j) ,
2471: tp_quantity = tp_quantity + t_tp_planned_order_qty(j)
2472: where publisher_id = t_pub_id(j)

Line 2480: update msc_sup_dem_entries

2476: and inventory_item_id = t_item_id(j)
2477: and trunc(key_date) = trunc(t_key_date(j))
2478: and publisher_order_type = CP_PLANNED_ORDER;
2479:
2480: update msc_sup_dem_entries
2481: set quantity = quantity + t_released_qty(j),
2482: primary_quantity = primary_quantity + t_released_qty(j),
2483: tp_quantity = tp_quantity + t_tp_released_qty(j)
2484: where publisher_id = t_pub_id(j)

Line 2500: update msc_sup_dem_entries

2496: ELSIF (t_order_type(j) = REQUISITION) THEN
2497:
2498: IF (t_base_item_id(j) is not null) THEN
2499:
2500: update msc_sup_dem_entries
2501: set quantity = quantity + t_qty(j),
2502: primary_quantity = primary_quantity + t_qty(j),
2503: tp_quantity = tp_quantity + t_tp_qty(j)
2504: where publisher_id = t_pub_id(j)

Line 2512: insert into msc_sup_dem_entries (

2508: and inventory_item_id = t_base_item_id(j)
2509: and trunc(key_date) = trunc(t_key_date(j))
2510: and publisher_order_type = ORDER_FORECAST;
2511: IF (SQL%ROWCOUNT = 0) THEN
2512: insert into msc_sup_dem_entries (
2513: transaction_id,
2514: plan_id,
2515: sr_instance_id,
2516: publisher_name,

Line 2572: msc_sup_dem_entries_s.nextval,

2568: planner_code,
2569: version,
2570: designator
2571: ) values (
2572: msc_sup_dem_entries_s.nextval,
2573: -1,
2574: -1,
2575: t_pub(j),
2576: t_pub_id(j),

Line 2633: update msc_sup_dem_entries

2629: p_designator);
2630: END IF; --rowcount
2631:
2632: ELSE
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 2650: update msc_sup_dem_entries

2646: ELSIF (t_order_type(j) = PURCHASE_ORDER) THEN
2647:
2648:
2649: IF (t_base_item_id(j) is not null) THEN
2650: update msc_sup_dem_entries
2651: set quantity = quantity + t_qty(j),
2652: primary_quantity = primary_quantity + t_qty(j),
2653: tp_quantity = tp_quantity + t_tp_qty(j)
2654: where publisher_id = t_pub_id(j)

Line 2662: update msc_sup_dem_entries

2658: and inventory_item_id = t_base_item_id(j)
2659: and trunc(key_date) = trunc(t_key_date(j))
2660: and publisher_order_type = ORDER_FORECAST;
2661: ELSE
2662: update msc_sup_dem_entries
2663: set quantity = quantity + t_qty(j),
2664: primary_quantity = primary_quantity + t_qty(j),
2665: tp_quantity = tp_quantity + t_tp_qty(j)
2666: where publisher_id = t_pub_id(j)

Line 2674: update msc_sup_dem_entries

2670: and inventory_item_id = t_item_id(j)
2671: and trunc(key_date) = trunc(t_key_date(j))
2672: and publisher_order_type = ORDER_FORECAST;
2673: END IF;
2674: update msc_sup_dem_entries
2675: set quantity = quantity + t_qty(j),
2676: primary_quantity = primary_quantity + t_qty(j) ,
2677: tp_quantity = tp_quantity + t_tp_qty(j)
2678: where publisher_id = t_pub_id(j)

Line 2693: update msc_sup_dem_entries

2689: begin
2690: IF (t_base_item_id(j) is not null) THEN
2691:
2692:
2693: update msc_sup_dem_entries
2694: set quantity = quantity + t_qty(j),
2695: primary_quantity = primary_quantity + t_qty(j),
2696: tp_quantity = tp_quantity + t_tp_qty(j)
2697: where publisher_id = t_pub_id(j)

Line 2706: insert into msc_sup_dem_entries (

2702: and trunc(key_date) = trunc(t_key_date(j))
2703: and publisher_order_type = ORDER_FORECAST;
2704:
2705: IF (SQL%ROWCOUNT = 0) THEN
2706: insert into msc_sup_dem_entries (
2707: transaction_id,
2708: plan_id,
2709: sr_instance_id,
2710: publisher_name,

Line 2766: msc_sup_dem_entries_s.nextval,

2762: planner_code,
2763: version,
2764: designator
2765: ) values (
2766: msc_sup_dem_entries_s.nextval,
2767: -1,
2768: -1,
2769: t_pub(j),
2770: t_pub_id(j),

Line 2826: update msc_sup_dem_entries

2822: p_version,
2823: p_designator);
2824: END IF; --rowcount
2825: ELSE
2826: update msc_sup_dem_entries
2827: set quantity = quantity + t_qty(j),
2828: primary_quantity = primary_quantity + t_qty(j),
2829: tp_quantity = quantity + t_tp_qty(j)
2830: where publisher_id = t_pub_id(j)

Line 2840: update msc_sup_dem_entries

2836: and publisher_order_type = ORDER_FORECAST;
2837:
2838: END IF;
2839:
2840: update msc_sup_dem_entries
2841: set quantity = quantity + t_planned_order_qty(j),
2842: primary_quantity = primary_quantity + t_planned_order_qty(j) ,
2843: tp_quantity = tp_quantity + t_tp_planned_order_qty(j)
2844: where publisher_id = t_pub_id(j)

Line 2852: update msc_sup_dem_entries

2848: and inventory_item_id = t_item_id(j)
2849: and trunc(key_date) = trunc(t_key_date(j))
2850: and publisher_order_type = CP_PLANNED_INBOUND_SHIPMENT;
2851:
2852: update msc_sup_dem_entries
2853: set quantity = quantity + t_released_qty(j),
2854: primary_quantity = primary_quantity + t_released_qty(j),
2855: tp_quantity = tp_quantity + t_tp_released_qty(j)
2856: where publisher_id = t_pub_id(j)

Line 2884: update msc_sup_dem_entries

2880: trunc(t_ship_date(j)) = trunc(t_ship_date(j-1)) and
2881: t_order_type(j) <> t_order_type(j-1)) THEN
2882:
2883: IF (t_base_item_id(j) is not null) THEN
2884: update msc_sup_dem_entries
2885: set quantity = quantity + t_qty(j),
2886: primary_quantity = primary_quantity + t_qty(j) ,
2887: tp_quantity = tp_quantity + t_tp_qty(j)
2888: where publisher_id = t_pub_id(j)

Line 2896: insert into msc_sup_dem_entries (

2892: and inventory_item_id = t_base_item_id(j)
2893: and trunc(key_date) = trunc(t_key_date(j))
2894: and publisher_order_type = ORDER_FORECAST;
2895: IF (SQL%ROWCOUNT = 0) THEN
2896: insert into msc_sup_dem_entries (
2897: transaction_id,
2898: plan_id,
2899: sr_instance_id,
2900: publisher_name,

Line 2956: msc_sup_dem_entries_s.nextval,

2952: planner_code,
2953: version,
2954: designator
2955: ) values (
2956: msc_sup_dem_entries_s.nextval,
2957: -1,
2958: -1,
2959: t_pub(j),
2960: t_pub_id(j),

Line 3017: update msc_sup_dem_entries

3013: p_designator);
3014: END IF; --rowcount
3015:
3016: ELSE
3017: update msc_sup_dem_entries
3018: set quantity = quantity + t_qty(j),
3019: primary_quantity = primary_quantity + t_qty(j) ,
3020: tp_quantity = tp_quantity + t_tp_qty(j)
3021: where publisher_id = t_pub_id(j)

Line 3047: insert into msc_sup_dem_entries (

3043: IF (t_planned_order_qty(j) < 0 ) THEN
3044: l_planned_order_qty := 0;
3045: l_tp_planned_order_qty := 0;
3046: END IF;
3047: insert into msc_sup_dem_entries (
3048: transaction_id,
3049: plan_id,
3050: sr_instance_id,
3051: publisher_name,

Line 3109: msc_sup_dem_entries_s.nextval,

3105: designator,
3106: base_item_id,
3107: base_item_name
3108: ) values (
3109: msc_sup_dem_entries_s.nextval,
3110: -1,
3111: -1,
3112: t_pub(j),
3113: t_pub_id(j),

Line 3186: insert into msc_sup_dem_entries (

3182: END IF;
3183: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '
3184: -- || t_tp_released_qty(j) || 'date ' || t_key_date(j));
3185: log_message( 'released qty ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
3186: insert into msc_sup_dem_entries (
3187: transaction_id,
3188: plan_id,
3189: sr_instance_id,
3190: publisher_name,

Line 3248: msc_sup_dem_entries_s.nextval,

3244: designator,
3245: base_item_id,
3246: base_item_name
3247: ) values (
3248: msc_sup_dem_entries_s.nextval,
3249: -1,
3250: -1,
3251: t_pub(j),
3252: t_pub_id(j),

Line 3321: insert into msc_sup_dem_entries (

3317:
3318: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
3319: --|| 'date ' || t_key_date(j));
3320: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));
3321: insert into msc_sup_dem_entries (
3322: transaction_id,
3323: plan_id,
3324: sr_instance_id,
3325: publisher_name,

Line 3383: msc_sup_dem_entries_s.nextval,

3379: designator,
3380: base_item_id,
3381: base_item_name
3382: ) values (
3383: msc_sup_dem_entries_s.nextval,
3384: -1,
3385: -1,
3386: t_pub(j),
3387: t_pub_id(j),

Line 3463: insert into msc_sup_dem_entries (

3459: l_tp_planned_order_qty := 0;
3460: END IF;
3461: log_message(' PIS ' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || ' date ' || t_key_date(j));
3462:
3463: insert into msc_sup_dem_entries (
3464: transaction_id,
3465: plan_id,
3466: sr_instance_id,
3467: publisher_name,

Line 3525: msc_sup_dem_entries_s.nextval,

3521: designator,
3522: base_item_id,
3523: base_item_name
3524: ) values (
3525: msc_sup_dem_entries_s.nextval,
3526: -1,
3527: -1,
3528: t_pub(j),
3529: t_pub_id(j),

Line 3601: insert into msc_sup_dem_entries (

3597: l_tp_released_qty := 0;
3598: END IF;
3599:
3600: log_message( 'released qty from PIS ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || ' date ' || t_key_date(j));
3601: insert into msc_sup_dem_entries (
3602: transaction_id,
3603: plan_id,
3604: sr_instance_id,
3605: publisher_name,

Line 3663: msc_sup_dem_entries_s.nextval,

3659: designator,
3660: base_item_id,
3661: base_item_name
3662: ) values (
3663: msc_sup_dem_entries_s.nextval,
3664: -1,
3665: -1,
3666: t_pub(j),
3667: t_pub_id(j),

Line 3750: FROM msc_sup_dem_entries

3746: l_count := 0;
3747:
3748: SELECT count(*)
3749: INTO l_count
3750: FROM msc_sup_dem_entries
3751: where publisher_id = t_pub_id(j)
3752: and publisher_site_id = t_pub_site_id(j)
3753: and supplier_id = t_supp_id(j)
3754: and supplier_site_id = t_supp_site_id(j)

Line 3761: update msc_sup_dem_entries

3757: and publisher_order_type = ORDER_FORECAST;
3758:
3759: IF l_count > 0 THEN
3760:
3761: update msc_sup_dem_entries
3762: set quantity = quantity + t_qty(j),
3763: primary_quantity = primary_quantity + t_qty(j) ,
3764: tp_quantity = tp_quantity + t_tp_qty(j)
3765: where publisher_id = t_pub_id(j)

Line 3775: insert into msc_sup_dem_entries (

3771: and publisher_order_type = ORDER_FORECAST;
3772: ELSE
3773:
3774: begin
3775: insert into msc_sup_dem_entries (
3776: transaction_id,
3777: plan_id,
3778: sr_instance_id,
3779: publisher_name,

Line 3835: msc_sup_dem_entries_s.nextval,

3831: planner_code,
3832: version,
3833: designator
3834: ) values (
3835: msc_sup_dem_entries_s.nextval,
3836: -1,
3837: -1,
3838: t_pub(j),
3839: t_pub_id(j),

Line 3920: insert into msc_sup_dem_entries (

3916: IF (t_planned_order_qty(j) < 0 ) THEN
3917: l_planned_order_qty := 0;
3918: l_tp_planned_order_qty := 0;
3919: END IF;
3920: insert into msc_sup_dem_entries (
3921: transaction_id,
3922: plan_id,
3923: sr_instance_id,
3924: publisher_name,

Line 3982: msc_sup_dem_entries_s.nextval,

3978: designator,
3979: base_item_id,
3980: base_item_name
3981: ) values (
3982: msc_sup_dem_entries_s.nextval,
3983: -1,
3984: -1,
3985: t_pub(j),
3986: t_pub_id(j),

Line 4059: insert into msc_sup_dem_entries (

4055: END IF;
4056: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '
4057: -- || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4058: log_message( 'released qty ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4059: insert into msc_sup_dem_entries (
4060: transaction_id,
4061: plan_id,
4062: sr_instance_id,
4063: publisher_name,

Line 4121: msc_sup_dem_entries_s.nextval,

4117: designator,
4118: base_item_id,
4119: base_item_name
4120: ) values (
4121: msc_sup_dem_entries_s.nextval,
4122: -1,
4123: -1,
4124: t_pub(j),
4125: t_pub_id(j),

Line 4193: insert into msc_sup_dem_entries (

4189: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4190: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
4191: --|| 'date ' || t_key_date(j));
4192: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));
4193: insert into msc_sup_dem_entries (
4194: transaction_id,
4195: plan_id,
4196: sr_instance_id,
4197: publisher_name,

Line 4255: msc_sup_dem_entries_s.nextval,

4251: designator,
4252: base_item_id,
4253: base_item_name
4254: ) values (
4255: msc_sup_dem_entries_s.nextval,
4256: -1,
4257: -1,
4258: t_pub(j),
4259: t_pub_id(j),

Line 4336: insert into msc_sup_dem_entries (

4332: l_tp_planned_order_qty := 0;
4333: END IF;
4334: log_message('PIS ' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || ' date ' || t_key_date(j));
4335:
4336: insert into msc_sup_dem_entries (
4337: transaction_id,
4338: plan_id,
4339: sr_instance_id,
4340: publisher_name,

Line 4398: msc_sup_dem_entries_s.nextval,

4394: designator,
4395: base_item_id,
4396: base_item_name
4397: ) values (
4398: msc_sup_dem_entries_s.nextval,
4399: -1,
4400: -1,
4401: t_pub(j),
4402: t_pub_id(j),

Line 4474: insert into msc_sup_dem_entries (

4470: l_tp_released_qty := 0;
4471: END IF;
4472: log_message( 'released qty from PIS ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4473:
4474: insert into msc_sup_dem_entries (
4475: transaction_id,
4476: plan_id,
4477: sr_instance_id,
4478: publisher_name,

Line 4536: msc_sup_dem_entries_s.nextval,

4532: designator,
4533: base_item_id,
4534: base_item_name
4535: ) values (
4536: msc_sup_dem_entries_s.nextval,
4537: -1,
4538: -1,
4539: t_pub(j),
4540: t_pub_id(j),

Line 4606: update msc_sup_dem_entries

4602: END LOOP;
4603:
4604: -- break into 2 queries for performance purpose
4605: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4606: update msc_sup_dem_entries
4607: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4608: where publisher_order_type = CP_PLANNED_ORDER
4609: and publisher_id = t_pub_id(j)
4610: and publisher_site_id = t_pub_site_id(j)

Line 4618: update msc_sup_dem_entries

4614: and quantity < 0;
4615:
4616:
4617: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4618: update msc_sup_dem_entries
4619: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4620: where publisher_order_type = CP_RELEASED_PLANNED_ORDER
4621: and publisher_id = t_pub_id(j)
4622: and publisher_site_id = t_pub_site_id(j)

Line 4631: update msc_sup_dem_entries

4627:
4628: -- added for PIS
4629:
4630: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4631: update msc_sup_dem_entries
4632: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4633: where publisher_order_type = CP_PLANNED_INBOUND_SHIPMENT
4634: and publisher_id = t_pub_id(j)
4635: and publisher_site_id = t_pub_site_id(j)

Line 4643: update msc_sup_dem_entries

4639: and quantity < 0;
4640:
4641:
4642: FORALL j in t_pub_id.FIRST..t_pub_id.LAST
4643: update msc_sup_dem_entries
4644: set quantity = 0, tp_quantity = 0, primary_quantity = 0
4645: where publisher_order_type = CP_RELEASED_INBOUND_SHIPMENT
4646: and publisher_id = t_pub_id(j)
4647: and publisher_site_id = t_pub_site_id(j)

Line 4748: update msc_sup_dem_entries

4744: l_qty := 0;
4745: l_tp_qty := 0;
4746: END IF;
4747: --=============
4748: update msc_sup_dem_entries
4749: set quantity = quantity + l_qty,
4750: primary_quantity = primary_quantity + l_qty,
4751: tp_quantity = tp_quantity + l_tp_qty
4752: where publisher_id = t_pub_id(j)

Line 4763: INSERT INTO msc_sup_dem_entries

4759:
4760: IF SQL%NOTFOUND THEN
4761: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',RETURNS_FORECAST);
4762: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4763: INSERT INTO msc_sup_dem_entries
4764: (transaction_id,
4765: plan_id,
4766: sr_instance_id,
4767: publisher_name,

Line 4825: msc_sup_dem_entries_s.nextval,

4821: designator,
4822: base_item_id,
4823: base_item_name)
4824: VALUES(
4825: msc_sup_dem_entries_s.nextval,
4826: -1,
4827: -1,
4828: t_pub(j),
4829: t_pub_id(j),

Line 4891: update msc_sup_dem_entries

4887:
4888: -- Publish DOS Start (only when Publish Defective Outbound Shipment = YES in MSCXPO)
4889: IF (p_publish_dos = 1 AND ( t_order_type(j) IN (ISO_DEF, INTRANSIT_SHIPMENT_DEF, INTRANSIT_RECEIPT_DEF))) THEN
4890:
4891: update msc_sup_dem_entries
4892: set quantity = quantity + l_qty,
4893: primary_quantity = primary_quantity + l_qty,
4894: tp_quantity = tp_quantity + l_tp_qty
4895: where publisher_id = t_pub_id(j)

Line 4908: INSERT INTO msc_sup_dem_entries

4904:
4905: IF SQL%NOTFOUND THEN
4906: l_order_type_desc:=MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',DEFECTIVE_OUTBOUND_SHIPMENT);
4907: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4908: INSERT INTO msc_sup_dem_entries
4909: (transaction_id,
4910: plan_id,
4911: sr_instance_id,
4912: publisher_name,

Line 4972: msc_sup_dem_entries_s.nextval,

4968: designator,
4969: base_item_id,
4970: base_item_name)
4971: VALUES(
4972: msc_sup_dem_entries_s.nextval,
4973: -1,
4974: -1,
4975: t_pub(j),
4976: t_pub_id(j),

Line 5119: delete from msc_sup_dem_entries sd

5115:
5116: log_message('l_supplier_site_id := ' || l_supplier_site_id);
5117:
5118: IF ( p_overwrite = 1) THEN --delete all
5119: delete from msc_sup_dem_entries sd
5120: where sd.publisher_order_type in (ORDER_FORECAST,CP_PLANNED_ORDER,
5121: CP_PURCHASE_ORDER_FROM_PLAN,CP_RELEASED_PLANNED_ORDER,
5122: CP_PLANNED_INBOUND_SHIPMENT, CP_RELEASED_INBOUND_SHIPMENT,
5123: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383

Line 5165: delete from msc_sup_dem_entries sd

5161: l_row := SQL%ROWCOUNT;
5162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
5163:
5164: ELSIF ( p_overwrite = 2) THEN --delete by overwritten
5165: delete from msc_sup_dem_entries sd
5166: where sd.publisher_order_type IN (ORDER_FORECAST, CP_PLANNED_ORDER,
5167: CP_PURCHASE_ORDER_FROM_PLAN, CP_RELEASED_PLANNED_ORDER,
5168: CP_PLANNED_INBOUND_SHIPMENT, CP_RELEASED_INBOUND_SHIPMENT,
5169: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383