DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_SUP_DEM_ENTRIES_S

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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