DBA Data[Home] [Help]

APPS.GMPMRRP dependencies on PS_WHSE_EFF

Line 506: FROM mr_tran_tbl trn, ps_whse_eff whs

502:
503: IF nvl(G_whse_security,'N') = 'N' THEN
504: OPEN Cur_matl_act for
505: SELECT distinct trn.whse_code, whs.whse_item_id
506: FROM mr_tran_tbl trn, ps_whse_eff whs
507: WHERE mrp_id = G_mrp_id
508: AND item_id = V_item_id
509: AND trn.whse_code >= X_fwhse_code
510: AND trn.whse_code <= X_twhse_code

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