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_ASSIGNMENTS

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

2246: , wdd2.transaction_temp_id
2247: , wdd2.serial_number
2248: , wdd2.source_header_id
2249: , wdd2.source_line_id
2250: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2, wsh_delivery_assignments_v wda
2251: WHERE wdd1.organization_id = p_organization_id
2252: AND wdd1.lpn_id = p_lpn_id
2253: AND wdd1.released_status = 'X' -- For LPN reuse ER : 6845650
2254: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id

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

2269: , wdd2.transaction_temp_id
2270: , wdd2.serial_number
2271: , wdd2.source_header_id
2272: , wdd2.source_line_id
2273: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2, wsh_delivery_assignments wda
2274: WHERE wdd1.organization_id = p_organization_id
2275: AND wdd1.lpn_id = p_lpn_id
2276: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id
2277: AND wdd2.delivery_detail_id = wda.delivery_detail_id