APPS.CHV_ITEM_ORDERS_S1 dependencies on CHV_ITEM_ORDERS

Line 1: PACKAGE BODY CHV_ITEM_ORDERS_S1 as

1: PACKAGE BODY CHV_ITEM_ORDERS_S1 as
2: /* $Header: CHVPRIOB.pls 115.1 2002/11/26 23:55:40 sbull ship $ */
3:
4: /*========================= CHV_ITEM_ORDERS_S1 ==============================*/
5:

Line 4: /*========================= CHV_ITEM_ORDERS_S1 ==============================*/

1: PACKAGE BODY CHV_ITEM_ORDERS_S1 as
2: /* $Header: CHVPRIOB.pls 115.1 2002/11/26 23:55:40 sbull ship $ */
3:
4: /*========================= CHV_ITEM_ORDERS_S1 ==============================*/
5:
6: /*=============================================================================
7:
8: PROCEDURE NAME: get_past_due_qty()

Line 25: FROM chv_item_orders

21: SELECT SUM(order_quantity),
22: SUM(order_quantity_primary)
23: INTO x_past_due_qty_purch,
24: x_past_due_qty_primary
25: FROM chv_item_orders
26: WHERE schedule_id = x_schedule_id
27: AND schedule_item_id = x_schedule_item_id
28: AND due_date < x_horizon_start_date
29: -- AND document_approval_status = 'FIRM'

Line 64: FROM chv_item_orders

60: SELECT SUM(order_quantity),
61: SUM(order_quantity_primary)
62: INTO x_authorization_qty,
63: x_authorization_qty_primary
64: FROM chv_item_orders
65: WHERE schedule_id = x_schedule_id
66: AND schedule_item_id = x_schedule_item_id
67: AND due_date < x_authorization_end_date;
68:

Line 76: END CHV_ITEM_ORDERS_S1;

72: RAISE;
73:
74: END get_auth_qty;
75:
76: END CHV_ITEM_ORDERS_S1;