DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_SUP_DEM_ENTRIES_S

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