DBA Data[Home] [Help]

APPS.GMPMRRP dependencies on SY_ORGN_USR

Line 519: FROM mr_tran_tbl trn, ps_whse_eff whs, sy_orgn_usr org

515: ORDER BY 1;
516: ELSE
517: OPEN Cur_matl_act for
518: SELECT distinct trn.whse_code, whs.whse_item_id --Bug 3168907 Added ps.whse_item_id
519: FROM mr_tran_tbl trn, ps_whse_eff whs, sy_orgn_usr org
520: WHERE mrp_id =G_mrp_id
521: AND item_id = V_item_id
522: AND trn.whse_code >= X_fwhse_code
523: AND trn.whse_code <= X_twhse_code