APPS.WMS_LPN_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 144: mtl_material_transactions_temp mmtt

140: NVL(wlpn.gross_weight, 0),
141: wlpn.content_volume_uom_code,
142: NVL(wlpn.content_volume, 0)
143: FROM wms_license_plate_numbers wlpn,
144: mtl_material_transactions_temp mmtt
145: WHERE wlpn.license_plate_number LIKE (p_lpn) and
146: mmtt.organization_id = p_org_id and
147: mmtt.cartonization_id = wlpn.lpn_id and
148: mmtt.subinventory_code = nvl(p_sub_code, mmtt.subinventory_code)

Line 874: mtl_material_transactions_temp mmtt

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(+)
877: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
878: AND msn.serial_number = msnt.fm_serial_number

Line 974: mtl_material_transactions_temp mmtt

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(+)
977: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
978: AND msn.serial_number = msnt.fm_serial_number

Line 1072: mtl_material_transactions_temp mmtt

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(+)
1075: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
1076: AND msn.serial_number = msnt.fm_serial_number

Line 4373: AND wlpn.lpn_id NOT IN ( select content_lpn_id from mtl_material_transactions_temp where content_lpn_id = wlpn.lpn_id)

4369: AND wlpn.license_plate_number LIKE (p_lpn)
4370: AND wlpn.subinventory_code = nvl(p_subinventory,wlpn.subinventory_Code)
4371: AND wlpn.locator_id = decode(p_locator,0,wlpn.locator_id,p_locator)
4372: AND wlpn.inventory_item_id is not null
4373: AND wlpn.lpn_id NOT IN ( select content_lpn_id from mtl_material_transactions_temp where content_lpn_id = wlpn.lpn_id)
4374: AND wlpn.parent_lpn_id is null
4375: AND wlpn.lpn_context = 1
4376: ORDER BY license_plate_number; --Inventory
4377: END GET_BULK_PACK_LPN;

Line 4469: FROM mtl_material_transactions_temp mmtt,

4465: CONNECT BY PRIOR
4466: wlpn1.lpn_id = wlpn1.parent_lpn_id)))
4467: OR
4468: (EXISTS (SELECT 'LOADED_BY_SAME_USER'
4469: FROM mtl_material_transactions_temp mmtt,
4470: wms_dispatched_tasks wdt
4471: WHERE mmtt.organization_id = p_organization_id
4472: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
4473: AND wdt.organization_id = p_organization_id