DBA Data[Home] [Help]

APPS.WMS_LPN_LOVS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 873: mtl_transaction_lots_temp mtlt,

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

Line 973: mtl_transaction_lots_temp mtlt,

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

Line 1071: mtl_transaction_lots_temp mtlt,

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