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_UI_RCV_LOVS dependencies on WMS_LPN_CONTENTS

Line 5976: exists ( select '1' from wms_lpn_contents wlc

5972: AND rsl.shipment_line_status_code in ('EXPECTED','PARTIALLY RECEIVED')
5973: AND rsl.to_organization_id= p_Organization_Id--Bug 3972931-Added the condiotn to filter based on organization_id
5974: and rsl.item_id = msn.inventory_item_id
5975: and ( (l_from_lpn_id is null) or (l_from_lpn_id is not null and
5976: exists ( select '1' from wms_lpn_contents wlc
5977: where wlc.parent_lpn_id = l_from_lpn_id
5978: and wlc.inventory_item_id = rsl.item_id
5979: ) )
5980: )

Line 6072: exists ( select '1' from wms_lpn_contents wlc

6068: and rsl.SHIPMENT_HEADER_ID = p_shipmentHeaderID
6069: AND rsl.shipment_line_status_code in ('EXPECTED','PARTIALLY RECEIVED')
6070: AND rsl.source_document_code = 'PO'
6071: and ( (l_from_lpn_id is null) or (l_from_lpn_id is not null and
6072: exists ( select '1' from wms_lpn_contents wlc
6073: where wlc.parent_lpn_id = l_from_lpn_id
6074: and wlc.inventory_item_id = msi.inventory_item_id
6075: ) )
6076: )

Line 6231: exists ( select '1' from wms_lpn_contents wlc

6227: and rsl.SHIPMENT_HEADER_ID = p_shipmentHeaderID
6228: and rsl.to_organization_id= p_Organization_Id--Bug 3972931-Added the condiotn to filter based on organization_id
6229: and rsl.item_id = msn.inventory_item_id
6230: and ( (l_from_lpn_id is null) or (l_from_lpn_id is not null and
6231: exists ( select '1' from wms_lpn_contents wlc
6232: where wlc.parent_lpn_id = l_from_lpn_id
6233: and wlc.inventory_item_id = rsl.item_id
6234: ) )
6235: )

Line 6453: ( select '1' from wms_lpn_contents wlc

6449: WHERE prl.requisition_header_id = p_reqHeaderID
6450: and rsl.item_id = inventory_item_id
6451: and ( (l_from_lpn_id is null)
6452: or (l_from_lpn_id is not null and exists
6453: ( select '1' from wms_lpn_contents wlc
6454: where wlc.parent_lpn_id = l_from_lpn_id
6455: and wlc.inventory_item_id = rsl.item_id
6456: )
6457: )

Line 6532: ( select '1' from wms_lpn_contents wlc

6528: WHERE prl.requisition_header_id = p_reqHeaderID
6529: and rsl.item_id = msi.inventory_item_id
6530: and ( (l_from_lpn_id is null)
6531: or (l_from_lpn_id is not null and exists
6532: ( select '1' from wms_lpn_contents wlc
6533: where wlc.parent_lpn_id = l_from_lpn_id
6534: and wlc.inventory_item_id = rsl.item_id
6535: )
6536: )

Line 6608: FROM wms_lpn_Contents wlc

6604: WHERE prl.Requisition_Header_Id = p_reqHeadeRid
6605: AND l_From_lpn_Id IS NOT NULL
6606: AND EXISTS
6607: (SELECT '1'
6608: FROM wms_lpn_Contents wlc
6609: WHERE wlc.Parent_lpn_Id = l_From_lpn_Id
6610: AND wlc.Inventory_Item_Id = rsl.Item_Id
6611: )
6612: AND prl.Requisition_Line_Id = rsl.Requisition_Line_Id

Line 6775: FROM wms_lpn_contents wlc

6771: AND ( (l_from_lpn_id IS NULL)
6772: OR (l_from_lpn_id IS NOT NULL
6773: AND EXISTS
6774: (SELECT '1'
6775: FROM wms_lpn_contents wlc
6776: WHERE wlc.parent_lpn_id = l_from_lpn_id
6777: AND wlc.inventory_item_id = rsl.item_id
6778: ) ) )
6779: AND prl.requisition_line_id = rsl.requisition_line_id

Line 7327: wms_lpn_contents wlc

7323: milk.concatenated_segments,
7324: wlpn.lpn_context
7325: FROM wms_license_plate_numbers wlpn,
7326: mtl_item_locations_kfv milk,
7327: wms_lpn_contents wlc
7328: WHERE wlpn.organization_id = milk.organization_id (+)
7329: AND wlpn.locator_id = milk.inventory_location_id(+)
7330: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
7331: AND wlpn.license_plate_number LIKE p_lpn

Line 7368: wms_lpn_contents wlc

7364: milk.concatenated_segments,
7365: wlpn.lpn_context
7366: FROM wms_license_plate_numbers wlpn,
7367: mtl_item_locations_kfv milk,
7368: wms_lpn_contents wlc
7369: WHERE wlpn.organization_id = milk.organization_id (+)
7370: AND wlpn.locator_id = milk.inventory_location_id(+)
7371: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
7372: AND wlpn.license_plate_number LIKE p_lpn

Line 7409: wms_lpn_contents wlc

7405: INV_PROJECT.GET_TASK_NUMBER,
7406: wlpn.lpn_context
7407: FROM wms_license_plate_numbers wlpn,
7408: mtl_item_locations_kfv milk,
7409: wms_lpn_contents wlc
7410: WHERE wlpn.organization_id = milk.organization_id (+)
7411: AND wlpn.locator_id = milk.inventory_location_id(+)
7412: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
7413: AND wlpn.license_plate_number LIKE p_lpn