[Home] [Help]
PACKAGE BODY: APPS.MRP_BIS_PLAN
Source
1 PACKAGE BODY MRP_BIS_PLAN AS
2 /* $Header: MRPPRODB.pls 115.0 99/07/16 12:34:11 porting ship $ */
3 FUNCTION sched_quant(
4 item_id in number,
5 org_id in number,
6 sched_desig in varchar2,
7 sched_date in date) return number is
8 quantity number;
9
10 begin
11 select nvl(sum(nvl(schedule_quantity, 0)),0)
12 into quantity
13 from mrp_schedule_dates
14 where inventory_item_id = item_id
15 and organization_id = org_id
16 and schedule_designator = sched_desig
17 and schedule_date = sched_date;
18
19 return quantity;
20 end;
21
22 end;