DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_SHIP_CONFIRM_RULES

Line 3696: wsh_ship_confirm_rules wscr

3692:
3693: CURSOR c_defer_interface(l_batch_id NUMBER) is
3694: SELECT DISTINCT wpr.pa_sc_batch_id, wscr.ac_defer_interface_flag
3695: FROM wsh_pr_workers wpr,
3696: wsh_ship_confirm_rules wscr
3697: WHERE wpr.batch_id = l_batch_id
3698: AND wpr.type = 'PS'
3699: AND wpr.sc_rule_id = wscr.SHIP_CONFIRM_RULE_ID
3700: AND NVL(EFFECTIVE_START_DATE, sysdate) <= sysdate

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

3702:
3703: CURSOR c_close_trip(l_pickrel_batch_id NUMBER) is
3704: SELECT DISTINCT wpr.batch_id, wpb.creation_date,
3705: wscr.ac_close_trip_flag, wscr.ac_intransit_flag
3706: FROM wsh_picking_batches wpb, wsh_ship_confirm_rules wscr, wsh_pr_workers wpr
3707: WHERE wpr.batch_id = l_pickrel_batch_id
3708: AND wpr.type = 'PS'
3709: AND wpb.batch_id = wpr.pa_sc_batch_id
3710: AND wpb.ship_confirm_rule_id = wscr.ship_confirm_rule_id