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;