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.WMS_LPN_LOVS dependencies on MTL_SERIAL_NUMBERS

Line 776: ' mtl_serial_numbers msn, ' ||

772: ' wlpn.lpn_context ' ||
773: 'FROM wms_license_plate_numbers wlpn, ' ||
774: ' mtl_item_locations_kfv milk, ' ||
775: ' wms_lpn_contents wlc, ' ||
776: ' mtl_serial_numbers msn, ' ||
777: ' mtl_serial_numbers_temp msnt ' ||
778: 'WHERE wlpn.organization_id = milk.organization_id (+) ' ||
779: ' AND wlpn.locator_id = milk.inventory_location_id(+) ' ||
780: ' AND wlc.parent_lpn_id (+) = wlpn.lpn_id ' ||

Line 777: ' mtl_serial_numbers_temp msnt ' ||

773: 'FROM wms_license_plate_numbers wlpn, ' ||
774: ' mtl_item_locations_kfv milk, ' ||
775: ' wms_lpn_contents wlc, ' ||
776: ' mtl_serial_numbers msn, ' ||
777: ' mtl_serial_numbers_temp msnt ' ||
778: 'WHERE wlpn.organization_id = milk.organization_id (+) ' ||
779: ' AND wlpn.locator_id = milk.inventory_location_id(+) ' ||
780: ' AND wlc.parent_lpn_id (+) = wlpn.lpn_id ' ||
781: ' AND msn.serial_number = msnt.fm_serial_number ' ||

Line 834: mtl_serial_numbers msn,

830: wlpn.lpn_context
831: FROM wms_license_plate_numbers wlpn,
832: mtl_item_locations_kfv milk,
833: wms_lpn_contents wlc,
834: mtl_serial_numbers msn,
835: mtl_serial_numbers_temp msnt
836: WHERE wlpn.organization_id = milk.organization_id (+)
837: AND wlpn.locator_id = milk.inventory_location_id(+)
838: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 835: mtl_serial_numbers_temp msnt

831: FROM wms_license_plate_numbers wlpn,
832: mtl_item_locations_kfv milk,
833: wms_lpn_contents wlc,
834: mtl_serial_numbers msn,
835: mtl_serial_numbers_temp msnt
836: WHERE wlpn.organization_id = milk.organization_id (+)
837: AND wlpn.locator_id = milk.inventory_location_id(+)
838: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
839: AND msn.serial_number = msnt.fm_serial_number

Line 871: mtl_serial_numbers msn,

867: wlpn.lpn_context
868: FROM wms_license_plate_numbers wlpn,
869: mtl_item_locations_kfv milk,
870: wms_lpn_contents wlc,
871: mtl_serial_numbers msn,
872: mtl_serial_numbers_temp msnt,
873: mtl_transaction_lots_temp mtlt,
874: mtl_material_transactions_temp mmtt
875: WHERE wlpn.organization_id = milk.organization_id (+)

Line 872: mtl_serial_numbers_temp msnt,

868: FROM wms_license_plate_numbers wlpn,
869: mtl_item_locations_kfv milk,
870: wms_lpn_contents wlc,
871: mtl_serial_numbers msn,
872: mtl_serial_numbers_temp msnt,
873: mtl_transaction_lots_temp mtlt,
874: mtl_material_transactions_temp mmtt
875: WHERE wlpn.organization_id = milk.organization_id (+)
876: AND wlpn.locator_id = milk.inventory_location_id(+)

Line 937: mtl_serial_numbers msn,

933: wlpn.lpn_context
934: FROM wms_license_plate_numbers wlpn,
935: mtl_item_locations_kfv milk,
936: wms_lpn_contents wlc,
937: mtl_serial_numbers msn,
938: mtl_serial_numbers_temp msnt
939: WHERE wlpn.organization_id = milk.organization_id (+)
940: AND wlpn.locator_id = milk.inventory_location_id(+)
941: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 938: mtl_serial_numbers_temp msnt

934: FROM wms_license_plate_numbers wlpn,
935: mtl_item_locations_kfv milk,
936: wms_lpn_contents wlc,
937: mtl_serial_numbers msn,
938: mtl_serial_numbers_temp msnt
939: WHERE wlpn.organization_id = milk.organization_id (+)
940: AND wlpn.locator_id = milk.inventory_location_id(+)
941: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
942: AND msn.serial_number = msnt.fm_serial_number

Line 971: mtl_serial_numbers msn,

967: wlpn.lpn_context
968: FROM wms_license_plate_numbers wlpn,
969: mtl_item_locations_kfv milk,
970: wms_lpn_contents wlc,
971: mtl_serial_numbers msn,
972: mtl_serial_numbers_temp msnt,
973: mtl_transaction_lots_temp mtlt,
974: mtl_material_transactions_temp mmtt
975: WHERE wlpn.organization_id = milk.organization_id (+)

Line 972: mtl_serial_numbers_temp msnt,

968: FROM wms_license_plate_numbers wlpn,
969: mtl_item_locations_kfv milk,
970: wms_lpn_contents wlc,
971: mtl_serial_numbers msn,
972: mtl_serial_numbers_temp msnt,
973: mtl_transaction_lots_temp mtlt,
974: mtl_material_transactions_temp mmtt
975: WHERE wlpn.organization_id = milk.organization_id (+)
976: AND wlpn.locator_id = milk.inventory_location_id(+)

Line 1034: mtl_serial_numbers msn,

1030: wlpn.lpn_context
1031: FROM wms_license_plate_numbers wlpn,
1032: mtl_item_locations_kfv milk,
1033: wms_lpn_contents wlc,
1034: mtl_serial_numbers msn,
1035: mtl_serial_numbers_temp msnt
1036: WHERE wlpn.organization_id = milk.organization_id (+)
1037: AND wlpn.locator_id = milk.inventory_location_id(+)
1038: AND wlc.parent_lpn_id (+) = wlpn.lpn_id

Line 1035: mtl_serial_numbers_temp msnt

1031: FROM wms_license_plate_numbers wlpn,
1032: mtl_item_locations_kfv milk,
1033: wms_lpn_contents wlc,
1034: mtl_serial_numbers msn,
1035: mtl_serial_numbers_temp msnt
1036: WHERE wlpn.organization_id = milk.organization_id (+)
1037: AND wlpn.locator_id = milk.inventory_location_id(+)
1038: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
1039: AND msn.serial_number = msnt.fm_serial_number

Line 1069: mtl_serial_numbers msn,

1065: wlpn.lpn_context
1066: FROM wms_license_plate_numbers wlpn,
1067: mtl_item_locations_kfv milk,
1068: wms_lpn_contents wlc,
1069: mtl_serial_numbers msn,
1070: mtl_serial_numbers_temp msnt,
1071: mtl_transaction_lots_temp mtlt,
1072: mtl_material_transactions_temp mmtt
1073: WHERE wlpn.organization_id = milk.organization_id (+)

Line 1070: mtl_serial_numbers_temp msnt,

1066: FROM wms_license_plate_numbers wlpn,
1067: mtl_item_locations_kfv milk,
1068: wms_lpn_contents wlc,
1069: mtl_serial_numbers msn,
1070: mtl_serial_numbers_temp msnt,
1071: mtl_transaction_lots_temp mtlt,
1072: mtl_material_transactions_temp mmtt
1073: WHERE wlpn.organization_id = milk.organization_id (+)
1074: AND wlpn.locator_id = milk.inventory_location_id(+)