APPS.CHV_CREATE_AUTHORIZATIONS dependencies on CHV_ITEM_ORDERS

Line 88: -- CHV_ITEM_ORDERS based on the authorization end date calculated above

84: p_horizon_end_date))
85: ) ;
86:
87: -- Get authorization quantities in purchasing and primary UOM's from
88: -- CHV_ITEM_ORDERS based on the authorization end date calculated above
89: -- for each authorization
90:
91: x_progress := '030';
92:

Line 103: FROM chv_item_orders cio

99: SELECT sum(order_quantity),
100: sum(order_quantity_primary)
101: INTO x_authorization_qty,
102: x_authorization_qty_primary
103: FROM chv_item_orders cio
104: WHERE cio.schedule_id = p_schedule_id
105: AND cio.schedule_item_id = p_schedule_item_id
106: AND cio.due_date between p_horizon_start_date and
107: x_auth_end_date ;