APPS.GMPMRACT dependencies on SY_ORGN_USR

Line 811: FROM mr_tran_tbl trn, ps_schd_dtl sch, sy_orgn_usr org, ps_whse_eff whs

807: ELSE
808: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id
809: OPEN Cur_matl_act for
810: SELECT distinct trn.whse_code, whs.whse_item_id
811: FROM mr_tran_tbl trn, ps_schd_dtl sch, sy_orgn_usr org, ps_whse_eff whs
812: WHERE sch.orgn_code = org.orgn_code
813: and sch.schedule_id = G_schedule_id
814: and mrp_id = G_mrp_id
815: and item_id = V_item_id