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

Line 47: from msc_sup_dem_entries sd,

43: nvl(sum(sd.primary_quantity),0),
44: nvl(sum(sd.tp_quantity),0),
45: nvl(sum(sd.quantity),0),
46: nvl(max(sd.last_refresh_number),0)
47: from msc_sup_dem_entries sd,
48: msc_cp_plan_buckets bkt
49: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
50: and sd.publisher_id = bkt.supplier_id
51: and sd.publisher_site_id = bkt.supplier_site_id

Line 100: from msc_sup_dem_entries sd,

96: nvl(sum(sd.primary_quantity),0),
97: nvl(sum(sd.tp_quantity),0),
98: nvl(sum(sd.quantity),0),
99: nvl(max(sd.last_refresh_number),0)
100: from msc_sup_dem_entries sd,
101: msc_cp_plan_buckets bkt
102: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
103: and sd.publisher_id = bkt.customer_id
104: and sd.publisher_site_id = bkt.customer_site_id

Line 161: from msc_sup_dem_entries sd,

157: nvl(sum(sd.primary_quantity),0),
158: nvl(sum(sd.tp_quantity),0),
159: nvl(sum(sd.quantity),0),
160: nvl(max(sd.last_refresh_number),0)
161: from msc_sup_dem_entries sd,
162: msc_cp_plan_buckets bkt
163: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
164: and sd.publisher_id = bkt.customer_id
165: and sd.publisher_site_id = bkt.customer_site_id

Line 214: from msc_sup_dem_entries sd,

210: nvl(sum(sd.primary_quantity),0),
211: nvl(sum(sd.tp_quantity),0),
212: nvl(sum(sd.quantity),0),
213: nvl(max(sd.last_refresh_number),0)
214: from msc_sup_dem_entries sd,
215: msc_cp_plan_buckets bkt
216: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
217: and sd.publisher_id = bkt.supplier_id
218: and sd.publisher_site_id = bkt.supplier_site_id

Line 262: from msc_sup_dem_entries sd,

258: bkt.bucket_index,
259: bkt.bkt_start_date,
260: bkt.bkt_end_date,
261: msc_x_netting_pkg.ORDER_FORECAST
262: from msc_sup_dem_entries sd,
263: msc_plan_buckets bkt
264: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
265: and sd.publisher_id = p_customer_id
266: and sd.publisher_site_id = p_customer_site_id

Line 283: from msc_sup_dem_entries sd,

279: bkt.bucket_index,
280: bkt.bkt_start_date,
281: bkt.bkt_end_date,
282: msc_x_netting_pkg.SUPPLY_COMMIT
283: from msc_sup_dem_entries sd,
284: msc_plan_buckets bkt
285: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
286: and sd.publisher_id = p_supplier_id
287: and sd.publisher_site_id = p_supplier_site_id

Line 346: FROM msc_sup_dem_entries sd1,

342: sd2.supplier_site_id,
343: sd2.supplier_site_name,
344: sd2.creation_date,
345: sd2.last_refresh_number
346: FROM msc_sup_dem_entries sd1,
347: msc_sup_dem_entries sd2
348: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
349: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
350: AND sd2.plan_id = sd1.plan_id

Line 347: msc_sup_dem_entries sd2

343: sd2.supplier_site_name,
344: sd2.creation_date,
345: sd2.last_refresh_number
346: FROM msc_sup_dem_entries sd1,
347: msc_sup_dem_entries sd2
348: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
349: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
350: AND sd2.plan_id = sd1.plan_id
351: AND sd2.inventory_item_id = sd1.inventory_item_id

Line 414: FROM msc_sup_dem_entries sd1,

410: sd2.customer_site_id,
411: sd2.customer_site_name,
412: sd2.creation_date,
413: sd2.last_refresh_number
414: FROM msc_sup_dem_entries sd1,
415: msc_sup_dem_entries sd2
416: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
417: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
418: AND sd2.plan_id = sd1.plan_id

Line 415: msc_sup_dem_entries sd2

411: sd2.customer_site_name,
412: sd2.creation_date,
413: sd2.last_refresh_number
414: FROM msc_sup_dem_entries sd1,
415: msc_sup_dem_entries sd2
416: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
417: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
418: AND sd2.plan_id = sd1.plan_id
419: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

Line 470: from msc_sup_dem_entries sd,

466: nvl(sum(sd.primary_quantity),0),
467: nvl(sum(sd.tp_quantity),0),
468: nvl(sum(sd.quantity),0),
469: nvl(max(sd.last_refresh_number),0)
470: from msc_sup_dem_entries sd,
471: msc_cp_plan_buckets bkt
472: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
473: and sd.publisher_id = bkt.supplier_id
474: and sd.publisher_site_id = bkt.supplier_site_id

Line 523: from msc_sup_dem_entries sd,

519: nvl(sum(sd.primary_quantity),0),
520: nvl(sum(sd.tp_quantity),0),
521: nvl(sum(sd.quantity),0),
522: nvl(max(sd.last_refresh_number),0)
523: from msc_sup_dem_entries sd,
524: msc_cp_plan_buckets bkt
525: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
526: and sd.publisher_id = bkt.customer_id
527: and sd.publisher_site_id = bkt.customer_site_id

Line 585: from msc_sup_dem_entries sd,

581: nvl(sum(sd.primary_quantity),0),
582: nvl(sum(sd.tp_quantity),0),
583: nvl(sum(sd.quantity),0),
584: nvl(max(sd.last_refresh_number),0)
585: from msc_sup_dem_entries sd,
586: msc_cp_plan_buckets bkt
587: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
588: and sd.publisher_id = bkt.customer_id
589: and sd.publisher_site_id = bkt.customer_site_id

Line 638: from msc_sup_dem_entries sd,

634: nvl(sum(sd.primary_quantity),0),
635: nvl(sum(sd.tp_quantity),0),
636: nvl(sum(sd.quantity),0),
637: nvl(max(sd.last_refresh_number),0)
638: from msc_sup_dem_entries sd,
639: msc_cp_plan_buckets bkt
640: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
641: and sd.publisher_id = bkt.supplier_id
642: and sd.publisher_site_id = bkt.supplier_site_id

Line 716: FROM msc_sup_dem_entries sd1,

712: sd2.supplier_site_id,
713: sd2.supplier_site_name,
714: sd2.creation_date,
715: sd2.last_refresh_number
716: FROM msc_sup_dem_entries sd1,
717: msc_sup_dem_entries sd2
718: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
719: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
720: AND sd2.plan_id = sd1.plan_id

Line 717: msc_sup_dem_entries sd2

713: sd2.supplier_site_name,
714: sd2.creation_date,
715: sd2.last_refresh_number
716: FROM msc_sup_dem_entries sd1,
717: msc_sup_dem_entries sd2
718: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
719: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
720: AND sd2.plan_id = sd1.plan_id
721: AND sd2.inventory_item_id = sd1.inventory_item_id

Line 784: FROM msc_sup_dem_entries sd1,

780: sd2.customer_site_id,
781: sd2.customer_site_name,
782: sd2.creation_date,
783: sd2.last_refresh_number
784: FROM msc_sup_dem_entries sd1,
785: msc_sup_dem_entries sd2
786: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
787: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
788: AND sd2.plan_id = sd1.plan_id

Line 785: msc_sup_dem_entries sd2

781: sd2.customer_site_name,
782: sd2.creation_date,
783: sd2.last_refresh_number
784: FROM msc_sup_dem_entries sd1,
785: msc_sup_dem_entries sd2
786: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
787: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
788: AND sd2.plan_id = sd1.plan_id
789: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

Line 935: l_item_desc msc_sup_dem_entries.item_description%type;

931: l_exception_group_name fnd_lookup_values.meaning%type;
932: l_posting_total_demand Number := 0;
933: l_posting_total_supply Number := 0;
934: l_sum Number := 0;
935: l_item_desc msc_sup_dem_entries.item_description%type;
936: l_shipping_control Number;
937: l_exception_basis msc_x_exception_details.exception_basis%type;
938:
939: l_last_so_trx_id Number;

Line 942: l_order_number msc_sup_dem_entries.order_number%type;

938:
939: l_last_so_trx_id Number;
940: l_receipt_date Date;
941: l_ship_date Date;
942: l_order_number msc_sup_dem_entries.order_number%type;
943: l_line_number msc_sup_dem_entries.line_number%type;
944: l_release_number msc_sup_dem_entries.release_number%type;
945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;

Line 943: l_line_number msc_sup_dem_entries.line_number%type;

939: l_last_so_trx_id Number;
940: l_receipt_date Date;
941: l_ship_date Date;
942: l_order_number msc_sup_dem_entries.order_number%type;
943: l_line_number msc_sup_dem_entries.line_number%type;
944: l_release_number msc_sup_dem_entries.release_number%type;
945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;

Line 944: l_release_number msc_sup_dem_entries.release_number%type;

940: l_receipt_date Date;
941: l_ship_date Date;
942: l_order_number msc_sup_dem_entries.order_number%type;
943: l_line_number msc_sup_dem_entries.line_number%type;
944: l_release_number msc_sup_dem_entries.release_number%type;
945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;

Line 945: l_item_name msc_sup_dem_entries.item_name%type;

941: l_ship_date Date;
942: l_order_number msc_sup_dem_entries.order_number%type;
943: l_line_number msc_sup_dem_entries.line_number%type;
944: l_release_number msc_sup_dem_entries.release_number%type;
945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;

Line 946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;

942: l_order_number msc_sup_dem_entries.order_number%type;
943: l_line_number msc_sup_dem_entries.line_number%type;
944: l_release_number msc_sup_dem_entries.release_number%type;
945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;

Line 947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;

943: l_line_number msc_sup_dem_entries.line_number%type;
944: l_release_number msc_sup_dem_entries.release_number%type;
945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;
951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

Line 948: l_publisher_name msc_sup_dem_entries.publisher_name%type;

944: l_release_number msc_sup_dem_entries.release_number%type;
945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;
951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
952: l_customer_name msc_sup_dem_entries.customer_name%type;

Line 949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;

945: l_item_name msc_sup_dem_entries.item_name%type;
946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;
951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
952: l_customer_name msc_sup_dem_entries.customer_name%type;
953: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

Line 950: l_supplier_name msc_sup_dem_entries.supplier_name%type;

946: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;
951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
952: l_customer_name msc_sup_dem_entries.customer_name%type;
953: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
954: l_publisher_id Number;

Line 951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

947: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;
951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
952: l_customer_name msc_sup_dem_entries.customer_name%type;
953: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
954: l_publisher_id Number;
955: l_publisher_site_id Number;

Line 952: l_customer_name msc_sup_dem_entries.customer_name%type;

948: l_publisher_name msc_sup_dem_entries.publisher_name%type;
949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;
951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
952: l_customer_name msc_sup_dem_entries.customer_name%type;
953: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
954: l_publisher_id Number;
955: l_publisher_site_id Number;
956: l_customer_id Number;

Line 953: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

949: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
950: l_supplier_name msc_sup_dem_entries.supplier_name%type;
951: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
952: l_customer_name msc_sup_dem_entries.customer_name%type;
953: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
954: l_publisher_id Number;
955: l_publisher_site_id Number;
956: l_customer_id Number;
957: l_customer_site_id Number;

Line 2390: from msc_sup_dem_entries

2386: BEGIN
2387: select transaction_id, receipt_date, ship_date, order_number, line_number, release_number
2388: into l_last_so_trx_id, b_so_receipt_date(j), b_so_ship_date(j), b_end_order_number(j),
2389: b_end_order_line_number(j), b_end_order_rel_number(j)
2390: from msc_sup_dem_entries
2391: where publisher_id = b_publisher_id(j)
2392: and publisher_site_id = b_publisher_site_id(j)
2393: and customer_id = b_customer_id(j)
2394: and customer_site_id = b_customer_site_id(j)

Line 2401: from msc_sup_dem_entries

2397: and end_order_number = b_order_number(j)
2398: and NVL(end_order_line_number,-1) = nvl(b_line_number(j),-1)
2399: and nvl(end_order_rel_number,-1) = nvl(b_release_number(j),-1)
2400: and key_date = (select max(key_date)
2401: from msc_sup_dem_entries
2402: where publisher_id = b_publisher_id(j)
2403: and publisher_site_id = b_publisher_site_id(j)
2404: and customer_id = b_customer_id(j)
2405: and customer_site_id = b_customer_site_id(j)

Line 2968: from msc_sup_dem_entries

2964: BEGIN
2965: select transaction_id, receipt_date, ship_date, order_number, line_number, release_number, last_refresh_number
2966: into l_last_so_trx_id, b_so_receipt_date(j), b_so_ship_date(j), b_end_order_number(j),
2967: b_end_order_line_number(j), b_end_order_rel_number(j), b_so_last_refnum(j)
2968: from msc_sup_dem_entries
2969: where publisher_id = b_supplier_id(j)
2970: and publisher_site_id = b_supplier_site_id(j)
2971: and customer_id = b_publisher_id(j)
2972: and customer_site_id = b_publisher_site_id(j)

Line 2979: from msc_sup_dem_entries

2975: and end_order_number = b_order_number(j)
2976: and NVL(end_order_line_number,-1) = nvl(b_line_number(j),-1)
2977: and nvl(end_order_rel_number,-1) = nvl(b_release_number(j),-1)
2978: and key_date = (select max(key_date)
2979: from msc_sup_dem_entries
2980: where publisher_id = b_supplier_id(j)
2981: and publisher_site_id = b_supplier_site_id(j)
2982: and customer_id = b_publisher_id(j)
2983: and customer_site_id = b_publisher_site_id(j)

Line 2997: from msc_sup_dem_entries

2993: END;
2994:
2995: SELECT max(last_refresh_number)
2996: into b_so_last_refnum(j)
2997: from msc_sup_dem_entries
2998: where publisher_id = b_supplier_id(j)
2999: and publisher_site_id = b_supplier_site_id(j)
3000: and customer_id = b_publisher_id(j)
3001: and customer_site_id = b_publisher_site_id(j)

Line 3495: l_item_desc msc_sup_dem_entries.item_description%type;

3491: l_exception_group_name fnd_lookup_values.meaning%type;
3492: l_posting_total_demand Number := 0;
3493: l_posting_total_supply Number := 0;
3494: l_sum Number := 0;
3495: l_item_desc msc_sup_dem_entries.item_description%type;
3496: l_shipping_control Number;
3497: l_exception_basis msc_x_exception_details.exception_basis%type;
3498:
3499: l_last_so_trx_id Number;

Line 3502: l_order_number msc_sup_dem_entries.order_number%type;

3498:
3499: l_last_so_trx_id Number;
3500: l_receipt_date Date;
3501: l_ship_date Date;
3502: l_order_number msc_sup_dem_entries.order_number%type;
3503: l_line_number msc_sup_dem_entries.line_number%type;
3504: l_release_number msc_sup_dem_entries.release_number%type;
3505: l_count Number:=0;
3506: l_item_name msc_sup_dem_entries.item_name%type;

Line 3503: l_line_number msc_sup_dem_entries.line_number%type;

3499: l_last_so_trx_id Number;
3500: l_receipt_date Date;
3501: l_ship_date Date;
3502: l_order_number msc_sup_dem_entries.order_number%type;
3503: l_line_number msc_sup_dem_entries.line_number%type;
3504: l_release_number msc_sup_dem_entries.release_number%type;
3505: l_count Number:=0;
3506: l_item_name msc_sup_dem_entries.item_name%type;
3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;

Line 3504: l_release_number msc_sup_dem_entries.release_number%type;

3500: l_receipt_date Date;
3501: l_ship_date Date;
3502: l_order_number msc_sup_dem_entries.order_number%type;
3503: l_line_number msc_sup_dem_entries.line_number%type;
3504: l_release_number msc_sup_dem_entries.release_number%type;
3505: l_count Number:=0;
3506: l_item_name msc_sup_dem_entries.item_name%type;
3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;

Line 3506: l_item_name msc_sup_dem_entries.item_name%type;

3502: l_order_number msc_sup_dem_entries.order_number%type;
3503: l_line_number msc_sup_dem_entries.line_number%type;
3504: l_release_number msc_sup_dem_entries.release_number%type;
3505: l_count Number:=0;
3506: l_item_name msc_sup_dem_entries.item_name%type;
3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;

Line 3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;

3503: l_line_number msc_sup_dem_entries.line_number%type;
3504: l_release_number msc_sup_dem_entries.release_number%type;
3505: l_count Number:=0;
3506: l_item_name msc_sup_dem_entries.item_name%type;
3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;

Line 3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;

3504: l_release_number msc_sup_dem_entries.release_number%type;
3505: l_count Number:=0;
3506: l_item_name msc_sup_dem_entries.item_name%type;
3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;
3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

Line 3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;

3505: l_count Number:=0;
3506: l_item_name msc_sup_dem_entries.item_name%type;
3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;
3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
3513: l_customer_name msc_sup_dem_entries.customer_name%type;

Line 3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;

3506: l_item_name msc_sup_dem_entries.item_name%type;
3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;
3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
3513: l_customer_name msc_sup_dem_entries.customer_name%type;
3514: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

Line 3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;

3507: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;
3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
3513: l_customer_name msc_sup_dem_entries.customer_name%type;
3514: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
3515: l_publisher_id Number;

Line 3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

3508: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;
3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
3513: l_customer_name msc_sup_dem_entries.customer_name%type;
3514: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
3515: l_publisher_id Number;
3516: l_publisher_site_id Number;

Line 3513: l_customer_name msc_sup_dem_entries.customer_name%type;

3509: l_publisher_name msc_sup_dem_entries.publisher_name%type;
3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;
3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
3513: l_customer_name msc_sup_dem_entries.customer_name%type;
3514: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
3515: l_publisher_id Number;
3516: l_publisher_site_id Number;
3517: l_customer_id Number;

Line 3514: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

3510: l_publisher_site_name msc_sup_dem_entries.publisher_site_name%type;
3511: l_supplier_name msc_sup_dem_entries.supplier_name%type;
3512: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
3513: l_customer_name msc_sup_dem_entries.customer_name%type;
3514: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
3515: l_publisher_id Number;
3516: l_publisher_site_id Number;
3517: l_customer_id Number;
3518: l_customer_site_id Number;

Line 4951: from msc_sup_dem_entries

4947: BEGIN
4948: select transaction_id, receipt_date, ship_date, order_number, line_number, release_number
4949: into l_last_so_trx_id, b_so_receipt_date(j), b_so_ship_date(j), b_end_order_number(j),
4950: b_end_order_line_number(j), b_end_order_rel_number(j)
4951: from msc_sup_dem_entries
4952: where publisher_id = b_publisher_id(j)
4953: and publisher_site_id = b_publisher_site_id(j)
4954: and customer_id = b_customer_id(j)
4955: and customer_site_id = b_customer_site_id(j)

Line 4962: from msc_sup_dem_entries

4958: and end_order_number = b_order_number(j)
4959: and NVL(end_order_line_number,-1) = nvl(b_line_number(j),-1)
4960: and nvl(end_order_rel_number,-1) = nvl(b_release_number(j),-1)
4961: and key_date = (select max(key_date)
4962: from msc_sup_dem_entries
4963: where publisher_id = b_publisher_id(j)
4964: and publisher_site_id = b_publisher_site_id(j)
4965: and customer_id = b_customer_id(j)
4966: and customer_site_id = b_customer_site_id(j)

Line 5543: from msc_sup_dem_entries

5539: BEGIN
5540: select transaction_id, receipt_date, ship_date, order_number, line_number, release_number, last_refresh_number
5541: into l_last_so_trx_id, b_so_receipt_date(j), b_so_ship_date(j), b_end_order_number(j),
5542: b_end_order_line_number(j), b_end_order_rel_number(j), b_so_last_refnum(j)
5543: from msc_sup_dem_entries
5544: where publisher_id = b_supplier_id(j)
5545: and publisher_site_id = b_supplier_site_id(j)
5546: and customer_id = b_publisher_id(j)
5547: and customer_site_id = b_publisher_site_id(j)

Line 5554: from msc_sup_dem_entries

5550: and end_order_number = b_order_number(j)
5551: and NVL(end_order_line_number,-1) = nvl(b_line_number(j),-1)
5552: and nvl(end_order_rel_number,-1) = nvl(b_release_number(j),-1)
5553: and key_date = (select max(key_date)
5554: from msc_sup_dem_entries
5555: where publisher_id = b_supplier_id(j)
5556: and publisher_site_id = b_supplier_site_id(j)
5557: and customer_id = b_publisher_id(j)
5558: and customer_site_id = b_publisher_site_id(j)

Line 5572: from msc_sup_dem_entries

5568: END;
5569:
5570: SELECT max(last_refresh_number)
5571: into b_so_last_refnum(j)
5572: from msc_sup_dem_entries
5573: where publisher_id = b_supplier_id(j)
5574: and publisher_site_id = b_supplier_site_id(j)
5575: and customer_id = b_publisher_id(j)
5576: and customer_site_id = b_publisher_site_id(j)