[Home] [Help]
2844:
2845: FORALL j in 1..t_pub_id.COUNT
2846:
2847: UPDATE msc_sup_dem_entries
2848: SET last_refresh_number = msc_cl_refresh_s.nextval,
2849: quantity = round((nvl(t_quantity(j),0)),6),
2850: tp_quantity = round((nvl(t_tp_quantity(j),0)),6),
2851: comments = t_comments(j),
2852: ship_date = t_ship_date(j),
3160: t_ins_shipto_id(j),
3161: t_ins_shipto_site_id(j),
3162: t_ins_shipto(j),
3163: t_ins_shipto_site(j),
3164: msc_cl_refresh_s.nextval,
3165: t_ins_release_number(j),
3166: t_ins_uom(j),
3167: t_new_ord_plac_date(j)
3168: , t_ins_vmi_flag(j)
3313: primary_uom = t_pri_uom(i),
3314: primary_quantity = round(t_primary_quantity(i), 6),
3315: key_date = sysdate,
3316: new_schedule_date = sysdate,
3317: last_refresh_number = msc_cl_refresh_s.nextval ,
3318: last_update_date = l_sysdate,
3319: last_updated_by = p_user_id
3320: where plan_id = G_PLAN_ID
3321: and sr_instance_id = G_SR_INSTANCE_ID
3544: /* t_ins_pub_id(i),
3545: t_ins_pub_site_id(i),
3546: t_ins_pub(i),
3547: t_ins_pub_site(i), */
3548: msc_cl_refresh_s.nextval,
3549: ---t_ins_supplier_item_name(i),
3550: t_ins_owner_item_name(i),
3551: ----t_ins_customer_item_name(i),
3552: ---t_ins_supplier_item_name(i),
3840: primary_uom = t_pri_uom(i),
3841: primary_quantity = round(t_primary_quantity(i), 6),
3842: key_date = sysdate,
3843: new_schedule_date = sysdate,
3844: last_refresh_number = msc_cl_refresh_s.nextval ,
3845: last_update_date = l_sysdate,
3846: last_updated_by = p_user_id,
3847: tp_quantity = round(t_tp_quantity(i), 6),
3848: tp_uom_code = t_tp_uom(i),
3887: primary_uom = t_pri_uom(i),
3888: primary_quantity = round(t_primary_quantity(i), 6),
3889: key_date = sysdate,
3890: new_schedule_date = sysdate,
3891: last_refresh_number = msc_cl_refresh_s.nextval ,
3892: last_update_date = l_sysdate,
3893: last_updated_by = p_user_id,
3894: tp_quantity = round(t_tp_quantity(i), 6),
3895: tp_uom_code = t_tp_uom(i),
4169: t_ins_supp(i)),
4170: DECODE(t_ins_alloc_type(i),
4171: G_SUPPLIER, t_ins_pub_site(i),
4172: t_ins_supp_site(i)),
4173: msc_cl_refresh_s.nextval,
4174: t_ins_supplier_item_name(i),
4175: t_ins_owner_item_name(i),
4176: t_ins_customer_item_name(i),
4177: t_ins_sup_item_desc(i),
4293: 2),
4294: ship_date = t_ship_date(i),
4295: receipt_date = t_receipt_date(i),
4296: key_date = t_key_date(i),
4297: last_refresh_number = msc_cl_refresh_s.nextval,
4298: end_order_number = t_end_order_number(i),
4299: end_order_line_number = t_end_order_line_number(i),
4300: end_order_rel_number = t_end_order_rel_number(i),
4301: end_order_publisher_id = t_end_ord_pub_id(i),
4682: t_ins_supp_id(i), ---- t_ins_pub_id(i) ,
4683: t_ins_supp_site_id(i) ,
4684: t_ins_supp(i) ,
4685: t_ins_supp_site(i) ,
4686: msc_cl_refresh_s.nextval,
4687: t_ins_tp_uom(i),
4688: round(t_ins_tp_quantity(i), 6),
4689: t_ins_base_item_id(i),
4690: t_ins_base_item_name(i),
5621: quantity = decode(t_status_code(i),'IT',t_quantity(i),0),
5622: primary_quantity = decode(t_status_code(i),'IT',t_quantity(i),0),
5623: tp_quantity = decode(t_status_code(i),'IT',t_quantity(i),0),
5624: sr_delivery_status_code = t_status_code(i),
5625: last_refresh_number = msc_cl_refresh_s.nextval,
5626: last_update_date = sysdate,
5627: last_updated_by = decode(t_status_code(i),'IT',p_user_id,-999)
5628: where plan_id = G_PLAN_ID
5629: and sr_instance_id = G_SR_INSTANCE_ID
5855: t_ins_shipto_id(j),
5856: t_ins_shipto_site_id(j),
5857: t_ins_shipto(j),
5858: t_ins_shipto_site(j),
5859: msc_cl_refresh_s.nextval,
5860: t_ins_uom(j),
5861: 1,
5862: t_ins_end_ord_num(j),
5863: t_ins_end_ord_line_num(j),
5927:
5928: BEGIN
5929:
5930: UPDATE MSC_SUP_DEM_ENTRIES msde1
5931: set last_refresh_number = msc_cl_refresh_s.nextval
5932: where plan_id = G_PLAN_ID
5933: --===========================================================
5934: -- Make sure that the Transaction is owned by non OEM Company
5935: -- and has reference to OEM Company.