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.INV_LPN_TRX_PUB dependencies on WSH_DELIVERY_DETAILS

Line 2467: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2, wsh_delivery_assignments_v wda

2463: , wdd2.transaction_temp_id
2464: , wdd2.serial_number
2465: , wdd2.source_header_id
2466: , wdd2.source_line_id
2467: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2, wsh_delivery_assignments_v wda
2468: WHERE wdd1.organization_id = p_organization_id
2469: AND wdd1.lpn_id = p_lpn_id
2470: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
2471: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id

Line 2491: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2, wsh_delivery_assignments wda

2487: , wdd2.serial_number
2488: , wdd2.source_header_id
2489: , wdd2.source_line_id
2490: , wdd2.source_code --16197273
2491: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2, wsh_delivery_assignments wda
2492: WHERE wdd1.organization_id = p_organization_id
2493: AND wdd1.lpn_id = p_lpn_id
2494: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id
2495: AND wdd2.delivery_detail_id = wda.delivery_detail_id

Line 5327: l_container_name wsh_delivery_details.container_name%TYPE;

5323: l_status_code VARCHAR2(1);
5324: l_delivery_id NUMBER;
5325: l_xfrlpn_ctx NUMBER;
5326: l_delivery_detail_id NUMBER;
5327: l_container_name wsh_delivery_details.container_name%TYPE;
5328: l_container_new_name wsh_delivery_details.container_name%TYPE;
5329: l_container_flag wsh_delivery_details.container_flag%TYPE;
5330: l_container_rec wsh_container_grp.changedattributetabtype;
5331:

Line 5328: l_container_new_name wsh_delivery_details.container_name%TYPE;

5324: l_delivery_id NUMBER;
5325: l_xfrlpn_ctx NUMBER;
5326: l_delivery_detail_id NUMBER;
5327: l_container_name wsh_delivery_details.container_name%TYPE;
5328: l_container_new_name wsh_delivery_details.container_name%TYPE;
5329: l_container_flag wsh_delivery_details.container_flag%TYPE;
5330: l_container_rec wsh_container_grp.changedattributetabtype;
5331:
5332: l_rtv_transaction_id NUMBER ;--RTV Change 16197273

Line 5329: l_container_flag wsh_delivery_details.container_flag%TYPE;

5325: l_xfrlpn_ctx NUMBER;
5326: l_delivery_detail_id NUMBER;
5327: l_container_name wsh_delivery_details.container_name%TYPE;
5328: l_container_new_name wsh_delivery_details.container_name%TYPE;
5329: l_container_flag wsh_delivery_details.container_flag%TYPE;
5330: l_container_rec wsh_container_grp.changedattributetabtype;
5331:
5332: l_rtv_transaction_id NUMBER ;--RTV Change 16197273
5333: l_source_header_id NUMBER :=NULL ;

Line 5338: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

5334: l_source_name VARCHAR2(100) := NULL ;
5335:
5336: CURSOR c_wdd_exists(p_transfer_lpn_id NUMBER,p_organization_id NUMBER) is
5337: SELECT distinct wda.delivery_id,wdd.delivery_detail_id,wdd.released_status
5338: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
5339: WHERE wdd.lpn_id IN (select lpn_id from wms_license_plate_numbers
5340: where organization_id = p_organization_id
5341: and (lpn_id = p_transfer_lpn_id
5342: or parent_lpn_id = p_transfer_lpn_id