eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMPMRACT dependencies on PS_SCHD_DTL

Line 795: FROM mr_tran_tbl trn, ps_schd_dtl sch, ps_whse_eff whs

791: IF nvl(G_whse_security,'N') = 'N' THEN
792: --Bug 3168907 Added ps_whse_eff whs to fetch whse_item_id
793: OPEN Cur_matl_act for
794: SELECT distinct trn.whse_code, whs.whse_item_id
795: FROM mr_tran_tbl trn, ps_schd_dtl sch, ps_whse_eff whs
796: WHERE sch.schedule_id = G_schedule_id
797: AND trn.mrp_id = G_mrp_id
798: AND item_id = V_item_id
799: AND whs.whse_code = trn.whse_code

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