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_PR_WORKERS

Line 607: FROM wsh_pr_workers

603: ) IS
604:
605: CURSOR c_get_printers IS
606: SELECT distinct printer_name
607: FROM wsh_pr_workers
608: WHERE batch_id = p_batch_id
609: AND organization_id = p_organization_id
610: AND type = 'PRINTER';
611:

Line 2333: FROM WSH_PR_WORKERS

2329:
2330: -- get distinct organization - move order header from worker table
2331: CURSOR get_org_mo_hdr(c_batch_id IN NUMBER) IS
2332: SELECT DISTINCT ORGANIZATION_ID, MO_HEADER_ID
2333: FROM WSH_PR_WORKERS
2334: WHERE BATCH_ID = c_batch_id
2335: AND PROCESSED = 'N'
2336: ORDER BY ORGANIZATION_ID;
2337:

Line 2341: FROM wsh_pr_workers

2337:
2338: -- get delivery information for auto ship and auto pack
2339: CURSOR c_get_del IS
2340: SELECT pa_sc_batch_id, delivery_id, organization_id, pickup_location_id, ap_level, sc_rule_id
2341: FROM wsh_pr_workers
2342: WHERE batch_id = p_batch_id
2343: AND type = 'PS'
2344: ORDER BY 1,3,2;
2345:

Line 3189: UPDATE WSH_PR_WORKERS

3185: l_total_detailed_count := 1;
3186: END IF;
3187: IF l_total_detailed_count > 0 THEN
3188:
3189: UPDATE WSH_PR_WORKERS
3190: SET detailed_count = detailed_count + l_total_detailed_count
3191: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID
3192: AND organization_id = batch_rec.organization_id
3193: AND type = 'DOC';

Line 3203: INSERT INTO WSH_PR_WORKERS (

3199: --{
3200: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3201: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3202: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i) IS NOT null THEN
3203: INSERT INTO WSH_PR_WORKERS (
3204: batch_id,
3205: type,
3206: organization_id,
3207: printer_name

Line 3217: FROM wsh_pr_workers

3213: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i)
3214: FROM dual
3215: WHERE NOT EXISTS (
3216: SELECT 'x'
3217: FROM wsh_pr_workers
3218: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID
3219: AND type = 'PRINTER'
3220: AND organization_id = batch_rec.organization_id
3221: AND printer_name = WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i));

Line 3267: FROM wsh_pr_workers

3263: WSH_DEBUG_SV.logmsg(l_module_name,'Getting lock for Del '||crec.delivery_id);
3264: END IF;
3265: SELECT 'x'
3266: INTO l_dummy
3267: FROM wsh_pr_workers
3268: WHERE batch_id = p_batch_id
3269: AND PA_SC_BATCH_ID = crec.PA_SC_BATCH_ID
3270: AND delivery_id = crec.delivery_id
3271: AND processed = 'N'

Line 3275: UPDATE wsh_pr_workers

3271: AND processed = 'N'
3272: FOR UPDATE NOWAIT;
3273: l_rec_found := TRUE;
3274:
3275: UPDATE wsh_pr_workers
3276: SET processed = 'Y'
3277: WHERE batch_id = p_batch_id
3278: AND PA_SC_BATCH_ID = crec.PA_SC_BATCH_ID
3279: AND delivery_id = crec.delivery_id;

Line 3664: FROM wsh_pr_workers

3660: l_backorder_rec_tbl WSH_USA_INV_PVT.Back_Det_Rec_Tbl;
3661:
3662: CURSOR c_batch_orgs(l_batch_id NUMBER) IS
3663: SELECT organization_id
3664: FROM wsh_pr_workers
3665: WHERE batch_id = l_batch_id
3666: AND type = 'DOC';
3667:
3668: CURSOR c_get_unassigned_details(l_batch_id NUMBER, l_organization_id NUMBER) IS

Line 3681: FROM wsh_pr_workers

3677:
3678: -- get total worker records for Pick Release
3679: CURSOR c_tot_worker_records(l_batch_id NUMBER) is
3680: SELECT COUNT(*)
3681: FROM wsh_pr_workers
3682: WHERE batch_id = l_batch_id
3683: AND type = 'PICK'
3684: AND PROCESSED = 'N';
3685:

Line 3688: FROM wsh_pr_workers

3684: AND PROCESSED = 'N';
3685:
3686: CURSOR c_sum_worker(l_batch_id NUMBER) is
3687: SELECT organization_id, mo_header_id, DETAILED_COUNT tot_detailed
3688: FROM wsh_pr_workers
3689: WHERE batch_id = l_batch_id
3690: AND type = 'DOC'
3691: ORDER BY organization_id;
3692:

Line 3695: FROM wsh_pr_workers wpr,

3691: ORDER BY organization_id;
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

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

Line 3809: FROM wsh_pr_workers

3805: AND NVL(wsp.appending_limit, 'N') <> 'N';
3806:
3807: CURSOR c_ap_batch(l_batch_id NUMBER) IS
3808: SELECT DISTINCT pa_sc_batch_id
3809: FROM wsh_pr_workers
3810: WHERE batch_id = l_batch_id
3811: AND type = 'PS'
3812: AND NVL(ap_level,0) > 0;
3813:

Line 3816: FROM wsh_pr_workers

3812: AND NVL(ap_level,0) > 0;
3813:
3814: CURSOR c_wms_orgs (l_batch_id NUMBER) IS
3815: SELECT organization_id, mo_header_id
3816: FROM wsh_pr_workers
3817: WHERE batch_id = l_batch_id
3818: AND type = 'WMS';
3819:
3820: -- X-dock changes to only select which have been released to warehouse from Inventory

Line 4564: INSERT INTO WSH_PR_WORKERS (

4560:
4561: -- 90.9 For WMS org with auto pick confirm as 'N', insert 'WMS' rec type in worker table
4562: IF l_org_info.wms_org = 'Y' AND l_org_info.auto_pick_confirm = 'N' THEN --{
4563: BEGIN
4564: INSERT INTO WSH_PR_WORKERS (
4565: BATCH_ID,
4566: TYPE,
4567: MO_HEADER_ID,
4568: ORGANIZATION_ID,

Line 4589: INSERT INTO WSH_PR_WORKERS (

4585: -- worker table or call init_cursor api to insert worker records
4586: -- Bug 5247554: Changed NVL(p_num_workers,1) to NVL(g_num_workers,1) in the below IF.
4587: IF NVL(g_num_workers,1) <= 1 THEN --{
4588: BEGIN
4589: INSERT INTO WSH_PR_WORKERS (
4590: BATCH_ID,
4591: TYPE,
4592: MO_HEADER_ID,
4593: MO_START_LINE_NUMBER,

Line 4656: INSERT INTO WSH_PR_WORKERS (

4652: END IF; --}
4653:
4654: -- 90.11 Insert DOC rec type in worker table
4655: BEGIN --{
4656: INSERT INTO WSH_PR_WORKERS (
4657: BATCH_ID,
4658: TYPE,
4659: MO_HEADER_ID,
4660: ORGANIZATION_ID,

Line 5738: INSERT INTO WSH_PR_WORKERS (

5734: );
5735:
5736: -- Bulk Insert
5737: FORALL i in 1..l_ps_delivery_tab.COUNT
5738: INSERT INTO WSH_PR_WORKERS (
5739: BATCH_ID,
5740: TYPE,
5741: PA_SC_BATCH_ID,
5742: DELIVERY_ID,

Line 5825: INSERT INTO WSH_PR_WORKERS (

5821: END IF;
5822:
5823: -- Bulk Insert
5824: FORALL i in 1..l_ps_delivery_tab.COUNT
5825: INSERT INTO WSH_PR_WORKERS (
5826: BATCH_ID,
5827: TYPE,
5828: PA_SC_BATCH_ID,
5829: DELIVERY_ID,

Line 6175: DELETE FROM wsh_pr_workers

6171: END IF; -- Close Stops / Run ITS / Run Auto Pack and Auto Ship Confirm Reports
6172:
6173: --{
6174: -- Delete records from Worker Table and Credit Check table
6175: DELETE FROM wsh_pr_workers
6176: WHERE batch_id = p_batch_id;
6177:
6178: DELETE FROM wsh_pr_header_holds
6179: WHERE batch_id = p_batch_id;