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.GMPMRRP dependencies on PS_SCHD_DTL

Line 473: FROM ps_schd_dtl

469:
470:
471: CURSOR Cur_min_max_orgn(p_schedule_id NUMBER) IS
472: SELECT min(orgn_code), max(orgn_code)
473: FROM ps_schd_dtl
474: WHERE schedule_id = p_schedule_id;
475: BEGIN
476: IF G_fwhse_code IS NULL THEN
477: SELECT MIN(whse_code) INTO X_fwhse_code FROM ic_whse_mst;

Line 512: AND whs.plant_code in (select orgn_code from ps_schd_dtl

508: AND item_id = V_item_id
509: AND trn.whse_code >= X_fwhse_code
510: AND trn.whse_code <= X_twhse_code
511: AND trn.whse_code = whs.whse_code
512: AND whs.plant_code in (select orgn_code from ps_schd_dtl
513: where schedule_id = G_schedule_id
514: AND orgn_code between X_forgn_code and X_torgn_code )
515: ORDER BY 1;
516: ELSE

Line 525: AND whs.plant_code in (select orgn_code from ps_schd_dtl

521: AND item_id = V_item_id
522: AND trn.whse_code >= X_fwhse_code
523: AND trn.whse_code <= X_twhse_code
524: AND trn.whse_code = whs.whse_code
525: AND whs.plant_code in (select orgn_code from ps_schd_dtl
526: where schedule_id = G_schedule_id
527: AND orgn_code between X_forgn_code and X_torgn_code )
528: and whs.plant_code = org.orgn_code
529: and org.user_id = G_Buyer_plnr_id