[Home] [Help]
17: CURSOR wt_cnt_rows IS
18: select count(*) from (
19: SELECT wdj.primary_item_id,wdj.bom_revision
20: FROM wip_transactions wt,
21: wip_discrete_jobs wdj
22: WHERE wt.transaction_date between p_from_date
23: and p_to_Date
24: AND wt.wip_entity_id = wdj.wip_entity_id
25: GROUP BY wdj.primary_item_id,