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 613: FROM wsh_pr_workers

609: ) IS
610:
611: CURSOR c_get_printers IS
612: SELECT distinct printer_name,conc_program_name
613: FROM wsh_pr_workers
614: WHERE batch_id = p_batch_id
615: AND organization_id = p_organization_id
616: AND type = 'PRINTER';
617:

Line 2394: FROM WSH_PR_WORKERS

2390:
2391: -- get distinct organization - move order header from worker table
2392: CURSOR get_org_mo_hdr(c_batch_id IN NUMBER) IS
2393: SELECT DISTINCT ORGANIZATION_ID, MO_HEADER_ID
2394: FROM WSH_PR_WORKERS
2395: WHERE BATCH_ID = c_batch_id
2396: AND PROCESSED = 'N'
2397: ORDER BY ORGANIZATION_ID;
2398:

Line 2402: FROM wsh_pr_workers

2398:
2399: -- get delivery information for auto ship and auto pack
2400: CURSOR c_get_del IS
2401: SELECT pa_sc_batch_id, delivery_id, organization_id, pickup_location_id, ap_level, sc_rule_id,ROWID -- Bug # 9369504 : added rowid
2402: FROM wsh_pr_workers
2403: WHERE batch_id = p_batch_id
2404: AND type = 'PS'
2405: ORDER BY 1,3,2;
2406:

Line 3256: -- Bug 9953872 - Need to update detailed_count in WSH_PR_WORKERS table,

3252:
3253: --}
3254: END LOOP;
3255:
3256: -- Bug 9953872 - Need to update detailed_count in WSH_PR_WORKERS table,
3257: -- so that move order header is NOT deleted in specific case where last
3258: -- batch of lines picked are ignored (say if all the lines are part of
3259: -- ship set and if there are some more lines in OM that are not interfaced
3260: -- yet to shipping).

Line 3271: UPDATE WSH_PR_WORKERS

3267: l_total_detailed_count := 1;
3268: END IF;
3269: IF l_total_detailed_count > 0 THEN
3270:
3271: UPDATE WSH_PR_WORKERS
3272: SET detailed_count = detailed_count + l_total_detailed_count
3273: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID
3274: AND organization_id = batch_rec.organization_id
3275: AND type = 'DOC';

Line 3289: INSERT INTO WSH_PR_WORKERS (

3285: --{
3286: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT > 0 THEN
3287: FOR i in 1..WSH_INV_INTEGRATION_GRP.G_PRINTERTAB.COUNT LOOP
3288: IF WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name IS NOT null THEN
3289: INSERT INTO WSH_PR_WORKERS (
3290: batch_id,
3291: type,
3292: organization_id,
3293: printer_name,

Line 3305: FROM wsh_pr_workers

3301: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name
3302: FROM dual
3303: WHERE NOT EXISTS (
3304: SELECT 'x'
3305: FROM wsh_pr_workers
3306: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID
3307: AND type = 'PRINTER'
3308: AND organization_id = batch_rec.organization_id
3309: AND printer_name = WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name

Line 3355: FROM wsh_pr_workers

3351: END IF;
3352: -- Bug # 9369504 : Added rowid in the where clause.
3353: SELECT 'x'
3354: INTO l_dummy
3355: FROM wsh_pr_workers
3356: WHERE rowid = crec.rowid
3357: AND processed = 'N'
3358: FOR UPDATE NOWAIT;
3359: l_rec_found := TRUE;

Line 3361: UPDATE wsh_pr_workers

3357: AND processed = 'N'
3358: FOR UPDATE NOWAIT;
3359: l_rec_found := TRUE;
3360:
3361: UPDATE wsh_pr_workers
3362: SET processed = 'Y'
3363: WHERE rowid= crec.rowid;
3364:
3365: EXCEPTION

Line 3752: FROM wsh_pr_workers

3748: l_backorder_rec_tbl WSH_USA_INV_PVT.Back_Det_Rec_Tbl;
3749:
3750: CURSOR c_batch_orgs(l_batch_id NUMBER) IS
3751: SELECT organization_id
3752: FROM wsh_pr_workers
3753: WHERE batch_id = l_batch_id
3754: AND type = 'DOC';
3755:
3756: CURSOR c_get_unassigned_details(l_batch_id NUMBER, l_organization_id NUMBER) IS

Line 3769: FROM wsh_pr_workers

3765:
3766: -- get total worker records for Pick Release
3767: CURSOR c_tot_worker_records(l_batch_id NUMBER) is
3768: SELECT COUNT(*)
3769: FROM wsh_pr_workers
3770: WHERE batch_id = l_batch_id
3771: AND type = 'PICK'
3772: AND PROCESSED = 'N';
3773:

Line 3776: FROM wsh_pr_workers

3772: AND PROCESSED = 'N';
3773:
3774: CURSOR c_sum_worker(l_batch_id NUMBER) is
3775: SELECT organization_id, mo_header_id, DETAILED_COUNT tot_detailed
3776: FROM wsh_pr_workers
3777: WHERE batch_id = l_batch_id
3778: AND type = 'DOC'
3779: ORDER BY organization_id;
3780:

Line 3783: FROM wsh_pr_workers wpr,

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

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

Line 3897: FROM wsh_pr_workers

3893: AND NVL(wsp.appending_limit, 'N') <> 'N';
3894:
3895: CURSOR c_ap_batch(l_batch_id NUMBER) IS
3896: SELECT DISTINCT pa_sc_batch_id
3897: FROM wsh_pr_workers
3898: WHERE batch_id = l_batch_id
3899: AND type = 'PS'
3900: AND NVL(ap_level,0) > 0;
3901:

Line 3904: FROM wsh_pr_workers

3900: AND NVL(ap_level,0) > 0;
3901:
3902: CURSOR c_wms_orgs (l_batch_id NUMBER) IS
3903: SELECT organization_id, mo_header_id
3904: FROM wsh_pr_workers
3905: WHERE batch_id = l_batch_id
3906: AND type = 'WMS'
3907: AND processed = 'N' --WMS High Vol Support, Added this AND cond and ORDER BY clause
3908: ORDER BY organization_id;

Line 4659: INSERT INTO WSH_PR_WORKERS (

4655:
4656: -- 90.9 For WMS org with auto pick confirm as 'N', insert 'WMS' rec type in worker table
4657: IF l_org_info.wms_org = 'Y' AND l_org_info.auto_pick_confirm = 'N' THEN --{
4658: BEGIN
4659: INSERT INTO WSH_PR_WORKERS (
4660: BATCH_ID,
4661: TYPE,
4662: MO_HEADER_ID,
4663: ORGANIZATION_ID,

Line 4684: INSERT INTO WSH_PR_WORKERS (

4680: -- worker table or call init_cursor api to insert worker records
4681: -- Bug 5247554: Changed NVL(p_num_workers,1) to NVL(g_num_workers,1) in the below IF.
4682: IF NVL(g_num_workers,1) <= 1 THEN --{
4683: BEGIN
4684: INSERT INTO WSH_PR_WORKERS (
4685: BATCH_ID,
4686: TYPE,
4687: MO_HEADER_ID,
4688: MO_START_LINE_NUMBER,

Line 4751: INSERT INTO WSH_PR_WORKERS (

4747: END IF; --}
4748:
4749: -- 90.11 Insert DOC rec type in worker table
4750: BEGIN --{
4751: INSERT INTO WSH_PR_WORKERS (
4752: BATCH_ID,
4753: TYPE,
4754: MO_HEADER_ID,
4755: ORGANIZATION_ID,

Line 5433: UPDATE wsh_pr_workers

5429: END IF;
5430:
5431: <>
5432: IF NVL(l_org_complete,'Y') = 'Y' THEN
5433: UPDATE wsh_pr_workers
5434: SET processed = 'Y'
5435: WHERE batch_id = p_batch_id
5436: AND organization_id = v_wms_org_rec.organization_id
5437: AND type = 'WMS';

Line 5873: INSERT INTO WSH_PR_WORKERS (

5869: );
5870:
5871: -- Bulk Insert
5872: FORALL i in 1..l_ps_delivery_tab.COUNT
5873: INSERT INTO WSH_PR_WORKERS (
5874: BATCH_ID,
5875: TYPE,
5876: PA_SC_BATCH_ID,
5877: DELIVERY_ID,

Line 5960: INSERT INTO WSH_PR_WORKERS (

5956: END IF;
5957:
5958: -- Bulk Insert
5959: FORALL i in 1..l_ps_delivery_tab.COUNT
5960: INSERT INTO WSH_PR_WORKERS (
5961: BATCH_ID,
5962: TYPE,
5963: PA_SC_BATCH_ID,
5964: DELIVERY_ID,

Line 6310: DELETE FROM wsh_pr_workers

6306: END IF; -- Close Stops / Run ITS / Run Auto Pack and Auto Ship Confirm Reports
6307:
6308: --{
6309: -- Delete records from Worker Table and Credit Check table
6310: DELETE FROM wsh_pr_workers
6311: WHERE batch_id = p_batch_id;
6312:
6313: DELETE FROM wsh_pr_header_holds
6314: WHERE batch_id = p_batch_id;