[Home] [Help]
62: var_start_id := arg_transid;
63:
64: SELECT publisher_order_type
65: INTO var_order_type
66: FROM msc_sup_dem_entries_ui_v -- msc_sup_dem_entries_ui_v
67: WHERE transaction_id = arg_transid ;
68:
69: if var_order_type <> PURCHASE_ORDER then
70:
75:
76: -- now start and peg down
77: SELECT a.transaction_id
78: BULK COLLECT INTO var_ids
79: FROM msc_sup_dem_entries a -- msc_sup_dem_entries_ui_v
80: WHERE exists
81: (select 1 from msc_sup_dem_security_v security
82: where security.transaction_id = a.transaction_id )
83: AND Level < RECEIPT_LEVEL
147:
148: -- PEG DOWN
149: SELECT count(a.transaction_id)
150: INTO v_ret_num
151: FROM msc_sup_dem_entries a-- msc_sup_dem_entries_ui_v
152: WHERE exists
153: (select 1 from msc_sup_dem_security_v security
154: where security.transaction_id = a.transaction_id )
155: AND a.transaction_id <> arg_transid -- else the starting rec will be counted as one
217: */
218:
219: Select publisher_order_type, receipt_date
220: Into v_order_type, v_receipt_date
221: From msc_sup_dem_entries_ui_v
222: Where transaction_id = arg_transid
223: and publisher_order_type in (PURCHASE_ORDER, SALES_ORDER, ASN);
224:
225: if v_order_type = SALES_ORDER OR v_order_type = ASN then
313: Select publisher_order_type,
314: decode(publisher_order_type,PURCHASE_ORDER,receipt_date,null),
315: decode(publisher_order_type,SALES_ORDER,receipt_date,null)
316: Into v_order_type, v_need_by_date, v_receipt_date
317: From msc_sup_dem_entries_ui_v
318: Where transaction_id = arg_transid
319: and publisher_order_type in (PURCHASE_ORDER, SALES_ORDER);
320:
321: IF v_order_type = SALES_ORDER THEN
323: v_start_id := get_immediate_po(arg_transid, v_order_type);
324:
325: Select receipt_date
326: Into v_need_by_date
327: From msc_sup_dem_entries_ui_v
328: Where transaction_id = v_start_id ;
329:
330: END IF;
331:
364: BEGIN
365:
366: Select publisher_order_type
367: Into v_order_type
368: From msc_sup_dem_entries_ui_v
369: Where transaction_id = arg_transid ;
370:
371: IF v_order_type = PURCHASE_ORDER then
372:
439:
440: -- peg UP
441: SELECT sd.transaction_id
442: INTO v_transid
443: FROM msc_sup_dem_entries sd -- msc_sup_dem_entries_ui_v
444: WHERE sd.publisher_order_type = PURCHASE_ORDER
445: AND sd.plan_id = -1
446: AND exists
447: (select 1 from msc_sup_dem_security_v security
504: customer_id, tp_quantity,
505: supplier_id, tp_quantity,
506: quantity)
507: INTO v_order_type, v_need_by_date, v_receipt_date, v_ontime_qty
508: FROM msc_sup_dem_entries_ui_v
509: WHERE transaction_id = arg_transid;
510:
511: /**
512: * if the order is SO
520: v_start_id := get_immediate_po(arg_transid,v_order_type) ;
521:
522: SELECT receipt_date
523: INTO v_need_by_date
524: FROM msc_sup_dem_entries_ui_v
525: WHERE transaction_id = v_start_id ;
526:
527: if v_need_by_date >= v_receipt_date then
528: v_ontime_qty:=round(v_ontime_qty,6);
608: customer_id, tp_quantity,
609: supplier_id, tp_quantity,
610: quantity)
611: INTO v_order_type, v_need_by_date, v_receipt_date, v_late_qty
612: FROM msc_sup_dem_entries_ui_v
613: WHERE transaction_id = arg_transid;
614:
615: /**
616: * if the order is SO
626: v_start_id := get_immediate_po(arg_transid,v_order_type) ;
627:
628: SELECT receipt_date
629: INTO v_need_by_date
630: FROM msc_sup_dem_entries_ui_v
631: WHERE transaction_id = v_start_id ;
632:
633: if v_need_by_date < v_receipt_date then
634: v_late_qty:=round(v_late_qty,6);
710: customer_id, tp_quantity,
711: supplier_id, tp_quantity,
712: quantity)
713: INTO v_order_type, v_intransit_qty
714: FROM msc_sup_dem_entries_ui_v
715: WHERE transaction_id = arg_transid
716: AND publisher_order_type in (PURCHASE_ORDER, ASN);
717:
718: if v_order_type = ASN then
789: customer_id, tp_quantity,
790: supplier_id, tp_quantity,
791: quantity)
792: INTO v_order_type, v_po_qty
793: FROM msc_sup_dem_entries_ui_v
794: WHERE transaction_id = arg_transid;
795:
796:
797: IF v_order_type = PURCHASE_ORDER then