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.WSH_PICK_LIST dependencies on WSH_SHIP_CONFIRM_RULES

Line 3784: wsh_ship_confirm_rules wscr

3780:
3781: CURSOR c_defer_interface(l_batch_id NUMBER) is
3782: SELECT DISTINCT wpr.pa_sc_batch_id, wscr.ac_defer_interface_flag
3783: FROM wsh_pr_workers wpr,
3784: wsh_ship_confirm_rules wscr
3785: WHERE wpr.batch_id = l_batch_id
3786: AND wpr.type = 'PS'
3787: AND wpr.sc_rule_id = wscr.SHIP_CONFIRM_RULE_ID
3788: AND NVL(EFFECTIVE_START_DATE, sysdate) <= sysdate

Line 3794: FROM wsh_picking_batches wpb, wsh_ship_confirm_rules wscr, wsh_pr_workers wpr

3790:
3791: CURSOR c_close_trip(l_pickrel_batch_id NUMBER) is
3792: SELECT DISTINCT wpr.batch_id, wpb.creation_date,
3793: wscr.ac_close_trip_flag, wscr.ac_intransit_flag
3794: FROM wsh_picking_batches wpb, wsh_ship_confirm_rules wscr, wsh_pr_workers wpr
3795: WHERE wpr.batch_id = l_pickrel_batch_id
3796: AND wpr.type = 'PS'
3797: AND wpb.batch_id = wpr.pa_sc_batch_id
3798: AND wpb.ship_confirm_rule_id = wscr.ship_confirm_rule_id